How can I create such a query in MS access so that only customers with more than 3 bookings show up? (1 Viewer)

akerikels46

New member
Local time
Today, 16:35
Joined
Dec 5, 2020
Messages
1
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 ? (Without using SQL)
 

theDBguy

I’m here to help
Staff member
Local time
Today, 04:05
Joined
Oct 29, 2018
Messages
21,358
Hi. Welcome to AWF!

You could try using a Totals query.
 

Gasman

Enthusiastic Amateur
Local time
Today, 11:05
Joined
Sep 21, 2011
Messages
14,050
Firstly, you should have the CustomerID in the bookings table, not the name etc.
As you do not want to use a query, look at DCount()
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 07:05
Joined
Feb 19, 2002
Messages
42,981
(Without using SQL)
What does that mean? How do you expect to work with a database engine without using SQL?
 

Users who are viewing this thread

Top Bottom