IIf and statement in MS Query

[confused.co.uk]

Hoping someone can help me. I am using MS Query to pull data in from an Access DB. I need to create a excel equivalent 'If AND' statement in ms query.

iif(and([CLCall]=1,[CLCall]=2),1,0)

But get a syntax error each time.
What am I doing wrong, pls help....

 

[Fazza]

'The value can never be 1 and 2. So, the logic isn't right.
 
'The syntax could be,
iif(CLCall = 1 AND CLCall = 2, 1, 0) AS [Resultant Field Name]
 
'Or maybe you want OR?
iif(CLCall = 1 OR CLCall = 2, 1, 0) AS [whatever]