G
Gale Coleman
Hello all,
Using Access 2000 and windows 2000 professional
I have a report that is based on a crosstab query that is based on another
query. I have a field on the report that sometimes does not have a record
on the database for it. When that happens I get the following error:
The Microsoft Jet Database Engine does not recognize " as a valid field name
or expression.
How can I write an IIF statement in the control source of the report to tell
the text field to be the value of 0 if there are no records for it?
Thanks,
gmc
Using Access 2000 and windows 2000 professional
I have a report that is based on a crosstab query that is based on another
query. I have a field on the report that sometimes does not have a record
on the database for it. When that happens I get the following error:
The Microsoft Jet Database Engine does not recognize " as a valid field name
or expression.
How can I write an IIF statement in the control source of the report to tell
the text field to be the value of 0 if there are no records for it?
Thanks,
gmc