I am trying to count records based on multiple criteria in the report footer in an unbound text box. I get an error that the expression is too complicated. Please advise
Sum(IIF([txtField1] = "value1" And [txtField2] = "value2",1,0))
Sum(IIF([txtField1] = "value1" Or [txtField2] = "value2" And [txtField3] ="value3",1,0))
I realize this may be able to be done in another way, but I am very new to Access queries. I am using Access 2003.
Thanks in advance.
Sum(IIF([txtField1] = "value1" And [txtField2] = "value2",1,0))
Sum(IIF([txtField1] = "value1" Or [txtField2] = "value2" And [txtField3] ="value3",1,0))
I realize this may be able to be done in another way, but I am very new to Access queries. I am using Access 2003.
Thanks in advance.