#Name? in a report

  • Thread starter Thread starter CD Tom
  • Start date Start date
C

CD Tom

I have a report that was working in 2003 but since I've switched to 2007 I
now get the #Name? In the report I do some calculating a GroupFooter0 in here
I do the following cal.
cctime1 = DSum("[Time1]", "[stagestats]", "[Time1] < 999 and class = '"
& Class & "'")
In the report section in the control Source I have =[cctime1] like I said
this worked just fine in access 2003 but not I get #Name?
Hopefully someone can tell me what's the difference between 2003 and 2007
that would cause this.
Thanks for any help.
 
CD said:
I have a report that was working in 2003 but since I've switched to 2007 I
now get the #Name? In the report I do some calculating a GroupFooter0 in here
I do the following cal.
cctime1 = DSum("[Time1]", "[stagestats]", "[Time1] < 999 and class = '"
& Class & "'")
In the report section in the control Source I have =[cctime1] like I said
this worked just fine in access 2003 but not I get #Name?
Hopefully someone can tell me what's the difference between 2003 and 2007
that would cause this.
Click to expand...


That calculation appears to be a VBA statement and cctime1 a
VBA variable. If that's the case, then I can not believe
that it ever worked. VBA variables can not be used outside
of a VBA procedure in the variable's declaration scope.

Maybe cctime1 was a text box that you removed??or its name
was changed??
 
Back
Top