Report works on all but 1 PC

[bobfin]

A new report in Access 2003 worked on all but one person's PC. That PC displayed the error message "The expression is typed incorrectly, or it too complex to be evaluated". The data source for the report was a query. Since one of the query columns was for a currency field that was null in the table instead of zero, that query column used the following expression to convert the nulls to zeros:
CCur(Nz([field],0))
The report finally worked on the bad PC by changing the expression to:
IIf(IsNull([field]),0,[field])
All the PCs were running Windows XP SP2 and Office 2003 (SP2 on the bad PC, no SP or SP3 on PCs that worked) . The library references were the same on all the PCs. The field showed on the report in the detail section and as a total in group footers.

So what would cause the behavior difference on that one PC?

 

[Moniker]

It sounds like you answered your own question -- put SP3 on the broken PC -- but in another question, what is the data source for the queries? I'm not sure how that would affect it, but NZ should work anywhere you use it as it's a built-in function. If the data source is something specific on a network that the "broken" PC doesn't have access to, that can be the problem, although that error message is misleading.