Query question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that returns a set of data based upon several tables. Works
fine. When I use one of these records in my app, I store the Primary Key in
another table (it can't be used again after the user selects it).

I would like my query to show all records except for those that I have save
in the table that records those records that have been used.

I do I this up? I can add the table to my query but the only relationship
options I get are to be inclusive in exclusive.

Thank you.

Ken
 
Ken said:
I have a query that returns a set of data based upon several tables. Works
fine. When I use one of these records in my app, I store the Primary Key in
another table (it can't be used again after the user selects it).

I would like my query to show all records except for those that I have save
in the table that records those records that have been used.

I do I this up? I can add the table to my query but the only relationship
options I get are to be inclusive in exclusive.
Click to expand...



Not sure I understand what you want, but try this kibd of
query:

SELECT yourquery.*
FROM yourquery LEFT JOIN savetable
ON yourtable.keyfield = savetable.keyfield
WHERE savetable.keyfield Is Null
 
Marshall:

PERFECT! You are the master. Thank you so much, saved me tons of time!

Have a great Day!
 
Back
Top