Query giving error "Microsoft access doesn't recognize as valid field or expression"

[jj1]

I have a cross tab query with parameters defined. Query runs fine. However when I run report it give me error "Microsoft access doesn't recognize as valid field or expression". So what's happening is I have 3 fields say A, B, C on the report . A is text fields others 2 are counts. If backend doesn't have data for say either field B or C then it gives me this error. Query is of full page I can post if somebody wants to see.

[ranman256]

You need to provide no data in case ther isn't any data.
i make sure to provide 0 to my fields so all fields exist.

[CJ_London]

could be null values in your data or perhaps you have a typo in one of your expressions - posting the code is unlikely to help. I would check your data first for nulls and protect against them (per ranmans suggestion, or use the nz function or filter them out) If you still get the error start to remove columns from your query until the error goes away and then rebuild from there

[jj1]

How do I make default value as 0 if no count exists in the report. I tried NZ and it didn't worked. In the back end there is only one field which as 2 values B and C. so for a particular date range there could be 10 A's and 0 B's. And if B has no values then report gives error.

could be null values in your data or perhaps you have a typo in one of your expressions - posting the code is unlikely to help. I would check your data first for nulls and protect against them (per ranmans suggestion, or use the nz function or filter them out) If you still get the error start to remove columns from your query until the error goes away and then rebuild from there

[CJ_London]

are you dividing by B values? if so, are you protecting from divide by zero errors?

from what you say, it sounds like it is a data/null issue so on reflection, if it is not the above, post your full sql with the exact error message