See if record exist - in sql query...

[Steff_DK]

Is it possible to make an iif in a SQL sentence that checks if a record with two given values exist?

What does the... uh.. "exist-function" look like?

I know the below will probably NOT work...
I want to do something like Iif(EXIST(

.[field]=criteria),1,0)

 

[RV]

Use the IN operator in a WHERE clause

WHERE column IN (value1, value2)

IN Operator is described in Access Help

RV