returning a list where they dont have a record! (1 Viewer)

iankerry

Registered User.
Local time
Today, 11:57
Joined
Aug 10, 2005
Messages
190
Hi,

hope you can help.

I have two tables: Venues and Events.

The Events table has a field called VenueID which tells me which venue the events will be at.

What I would like is a list of venues that haven't booked for the coming season.

so within a given date period, I would like a list of venues that have no records in the Events table.

Sounds simple, but i have no idea where to start to query for the absence of something!

thanks

ian
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 04:57
Joined
Aug 30, 2003
Messages
36,118
Create a query of events within the desired period, then use the unmatched query wizard to compare that query to the venues table.
 

iankerry

Registered User.
Local time
Today, 11:57
Joined
Aug 10, 2005
Messages
190
Thanks, that worked a treat!
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 04:57
Joined
Aug 30, 2003
Messages
36,118
Happy to help!
 

Users who are viewing this thread

Top Bottom