returning a list where they dont have a record!

[iankerry]

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]

Create a query of events within the desired period, then use the unmatched query wizard to compare that query to the venues table.

 

[iankerry]

Thanks, that worked a treat!

 

[pbaldy]

Happy to help!