Check if table contains tuple

  • Thread starter Thread starter Jeroen Verdrengh
  • Start date Start date
J

Jeroen Verdrengh

Hi,

How can I check whether a table contains a certain value in one of his
columns?

greets,

Jeroen
 
To be more clear: I wan't to use this expression to exclude records from a
query when their ID is in a table.
 
Hi,

Check each individual field.


SELECT *
FROM somewhere
WHERE f1<>id AND f2<>id AND f3<>id AND ... ad nauseam



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top