Help with query please

  • Thread starter Thread starter Liz J
  • Start date Start date
L

Liz J

Access 2002

I have 3 tables.

Band
Concert
Booking

Where booking is the table that breaks the many to many relationship and
holds details of which bands are booked into which concerts.

Using the query in Access (rather than the SQL) how do we produce a list of
bands that are not booked into any concerts?

Thanks

Liz
 
Liz

It sounds like you are looking for Bands that don't show up in Bookings.
There's a query wizard to help you do this "unmatched" query.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Jeff Boyce said:
Liz

It sounds like you are looking for Bands that don't show up in Bookings.
There's a query wizard to help you do this "unmatched" query.
Click to expand...

Thanks Jeff, I normally use the design view of query.

However, I have now tried by using the query wizard but apart from offering
me the option of a summary, there was no opportunity to find unmatched
records.

Where is the 'unmatched' query in Access?

Cheers

Liz
 
When I start in the database window, with Tables (or Queries) selected, and
click on the New Object Toolbar button, I get a choice of new forms or
reports or queries or ...

When I select query, I get a choice of Unmatched, Duplicate, etc... queries.

Are you starting out this way?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Jeff Boyce said:
When I start in the database window, with Tables (or Queries) selected,
and click on the New Object Toolbar button, I get a choice of new forms or
reports or queries or ...

When I select query, I get a choice of Unmatched, Duplicate, etc...
queries.

Are you starting out this way?

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...

Hi Jeff

No I was starting off by choosing Queries in the database window and then
either choosing New query in Design View or New query using the Wizard. I
had never used the New Object toolbar button before. I have now and it
worked like a dream. Cheers

Liz
 
Back
Top