Need Help finding a field which does not appear in the future.

[jbruno]

Here is my problem. I have two tables. 1 has all my general information including a "QSE Number" (text field). Another table has the "QSE Number" (text) and "QSE Name" (text). I have "QSE Number" related in both tables.

I have no problem creating a query that outputs all records who's due date is in the future with the cooresponding QSE number and QSE Name.

I would like to make a query to output all QSE Numbers and Names which do not appear in records who's due dates are in the future. Basically, I need to know which QSE Numbers are completed.

I am not sure how to write an expression in the query to do this. Thank you and please let me know if additional information is needed.

 

[David R]

I think you want to look into the Find Unmatched Query Wizard. Select that option when you start a New Query and see if that helps.