#name? access 2003

R

rlw00069

I have reports running fine under access 2000, but when I try to run the same
reports under Access 2003 I get #name? errors on the reports. This appears to
happen for calculated variables only. What changed from 2000 to 2003 that
makes my reports non-compatible?
 
F

fredg

I have reports running fine under access 2000, but when I try to run the same
reports under Access 2003 I get #name? errors on the reports. This appears to
happen for calculated variables only. What changed from 2000 to 2003 that
makes my reports non-compatible?
Click to expand...

The #Name error usually occurs when Access can not find a field
referred to in it's control source. It could be a simple miss-spelling
or a field that has had it's name changed, or a field name that
includes a space in it and is not surrounded with brackets i.e. [Last
Name], etc. You'll need to look.
A few examples of the expressions used would have been helpful.
 
Top