Query Question

[CarlV]

I had great success on this board yesterday with the help of a very patient individual. I'm hoping I can go two for two with you folks.



Access Front End for Forms, MySQL backend for data storage.

Two tables:
1 - customer sign-in
2 - customer sign-out

Each table shares a common Column in "Ticket #".

I would like to do a query where I can view all items in the 'customer sign-in' table, but I need it to query only those records that don't share a "Ticket #" with the items in 'customer sign-out'. In other words, it would show me what's still Signed In to the service desk, and hasn't been Signed Out.

Make any sense to anyone? I tried doing the join, but there are only 3 options for making the query show data....none of them are what I'm looking for.

Carl

[alansidman]

Open a new query in Access. Click on the Unmatched Query Wizard.

Alan

[CarlV]

Alan,

Thank you! Exactly what I was looking for!!!!

Carl