Hi Everyone,
We recently upgraded Access to 2010 and one of our queries now returns #error.
=IIf(IIf(Month(Date())=1,13,Month(Date()))<2," ",Count(IIf(([OR_Test_Type_1]='ID Data' Or [OR_Test_Type_1]='Local / ID Data' Or [OR_Test_Type_1]='Local / MAC' Or [OR_Test_Type_1]='Topical / ID Data' Or [OR_Test_Type_1]='MAC / Topical / ID Sed' Or [OR_Test_Type_1]='Data Block' Or [OR_Test_Type_1]='Data Mac') And [Expr1]='01',[OR_Test_Type_1])))
If we remove the text highlighted in red, it runs just fine. I'm guessing the Count is not returning a value when it looks for 'Data Block and Mac'? Does anyone know how to use HasData or maybe change the count to a sum operator to get this to work again?
Thanks,
Khen