How can I create such a query in MS access so that only customers with more than 3 bookings show up? I have two different tables, the "customers" tables, with "customer ID" as the primary field and a few more fields such as Name, Surname etc. (All in text format). 

The second table is "Booking details", It has the primary key as "Booking ID" and then customer name, surname etc, (Again, all in text) 

So, basically, in the Booking details table, each booking is given a unique Booking ID, and one customer can do several bookings, i want to create a query that sorts out only customer with more than 3 bookings ?
SELECT Customers.Customer_ID
FROM Customers
INNER JOIN Bookings 
    ON Customers.Customer_ID = Bookings.Customer_ID
GROUP BY Customers.Customer_ID
HAVING COUNT(Customers.Customer_ID) &gt; 3


Visually (some terms are approximate because I have no MS Access with English interface):


Add both tables to Query pane
Join them by proper fields
Select fields from Customers table which you want to output, do NOT add fields from Booking table
Press Totals knob on the ribbon
Add one more Customers.Customer_ID to the fields list
Change its Grouping function from Grouping by to Count
Set the criteria for this field to >3
Uncheck Show if you do not need in its value