How do I set up a formula not equal to in Access

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

Guest

I am tryring to eliminate accounts not matching another group of accounts
from another table
 
Query the table that you want to eliminate records from. To isolate records,
use the fields that will match/not match the accounts from the other table.
In the Criteria: area of the design grid, for each field, enter a "not equal"
expression relating to the table with the matching accounts.

For instance, you have a KeepTable, with fields item1, item2. This lists
accounts that you want to match and keep. You also have an EliminateTable,
also with fields item1, item2. You want to query the EliminateTable, and
flag records that don't match KeepTable accounts. Your Criteria for item1
would be "<>[KeepTable]![item1]", and for item2 would be
"<>[KeepTablel]![item1]".

If your query successfully isolates the appropriate records, it can be
changed to a Delete query to actually remove the records.
 
Back
Top