Left function in report

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

 

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

 

[klw]

Thank you, that was it.

Kevin

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

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.