SQL DIFFERENCE & MS Access Not In

  • Thread starter Thread starter Wendy Parry
  • Start date Start date
W

Wendy Parry

Hi,
Does anyone have the correct syntax for the Not In criteria clause?

I'm trying to get the difference between two sets of records, but am
having a few problems. One recordset is a table created from an append
query, the other is a query based upon a linked table. Basically for
accounting purposes I am having to extract some accounting records, but
this can't be done in one go, as the season continues, new records will
be added to the original booking table and I'll be trying to extract
these new bookings to append to the accounting table.

I can't use a booking date criteria, as there isn't one in the original db.

Many thanks

Wendy
 
Not enough detail about your tables/queries to give a full answer.

Is there one field in both the query and the table that is able to uniquely
identify the record and can be used to match the records between the two
tables? If so, take a look at the find Unmatched query wizard - (query tab,
press New, select Find Unmatched query wizard)

The same type of query can be built with multiple fields. The query wizard
only handles one field.
 
it's okay, I resolved it by using "Not Exist" it was just a case of
translating Relational Algebra DIFFERENCE to MS Access SQL syntax.
 
Back
Top