Left function in report

  • Thread starter Thread starter Kevin Willyerd
  • Start date Start date
K

Kevin Willyerd

I have a report that I group on =left([Department],2) and
the grouping and totals works fine BUT when I use the same
formula to print the information (ie the first two numbers
in the department number) in the group footer or header I
just get an #Error.
 
Is there a textbox on the report that is also called Department (possibly, the one you are
doing this in)? If so, try changing its name to txtDepartment. The name of the textbox can
be changed on the Other tab of the Properties window.
 
Thank you, that was it.

Kevin

Wayne Morgan said:
Is there a textbox on the report that is also called Department (possibly, the one you are
doing this in)? If so, try changing its name to txtDepartment. The name of the textbox can
be changed on the Other tab of the Properties window.

--
Wayne Morgan


Kevin Willyerd said:
I have a report that I group on =left([Department],2) and
the grouping and totals works fine BUT when I use the same
formula to print the information (ie the first two numbers
in the department number) in the group footer or header I
just get an #Error.
Click to expand...
Click to expand...
 
Back
Top