Hi All,
I am currently using Access 2003 and have an unbound text box in a report with the following code:
=Count(IIf([Complaints Table]![Month]=1,IIf([Complaints Table]![Decision - Our Favour?]="Y",0)))
The problem that I am experiencing is that I keep getting a "#Error" message in the text box when I run the report.
However, the puzzling thing is that I have an identical report in Access 2010 with the same text box and code which works perfectly. I am relatively new to access so i might be missing a trick here! If anyone could help that would be brilliant.
Thanks,
J.
I am currently using Access 2003 and have an unbound text box in a report with the following code:
=Count(IIf([Complaints Table]![Month]=1,IIf([Complaints Table]![Decision - Our Favour?]="Y",0)))
The problem that I am experiencing is that I keep getting a "#Error" message in the text box when I run the report.
However, the puzzling thing is that I have an identical report in Access 2010 with the same text box and code which works perfectly. I am relatively new to access so i might be missing a trick here! If anyone could help that would be brilliant.
Thanks,
J.