Avatar of LillyC
Flag for United Kingdom of Great Britain and Northern Ireland

asked on 

IIf query


I'm trying to return a value of 1 if Place is greater than 1 and SPfavcode is not equal to F.

FR: IIf([Place]>1 And [SPfavcode]<>"F",1,0) - I've created this but it doesn't work.

Can anyone help?
Microsoft Access

Avatar of undefined
Last Comment
crystal (strive4peace) - Microsoft MVP, Access

8/22/2022 - Mon