subtraction query

  • Thread starter Thread starter Wim
  • Start date Start date
W

Wim

Hi all,

I want to create an subtraction query but can't remember
the syntax.

I have two queries where the unique key is "Id".
I want to subtract the "bad" values in the second query
(Q2) from the "global" query (Q1), based on the equal
value of Id in Q1 and Q2.
So if I have e.g. 2000 records in Q1 and 25 in Q2, I want
to have 1975 records in the resulting query, all 25
records from Q2 having "disappeared".

Thanks for helping,

Wim
 
Back
Top