Left function in report

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.
 
W

Wayne Morgan

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.
 
K

klw

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...
 
Top