Expressions on Reports

  • Thread starter Thread starter Don Whitaker
  • Start date Start date
D

Don Whitaker

I am using Accss 2000 to create a report, but I can't
seem to use expressions on my report to any degree of
luck. My report runs off of a query. It looks like
anything that I want a function on or calculate I have to
do it in the query and not in the report on the control
source property. Is that right or am I missing something.
It looks like I cannot use =[PayType] to display a field
on the report?
When I use =[PayType] I get an #Error the function I'm
trying use is UCase I thought the expression should be
=UCase([PayType]), but all I get is #Error, now when I
put in the query expPType:Ucase([PayType]) it works fine?

I am also trying to do minor formatting and string
concatenation, but I guess I have to do it in the query?
Any advice is appreciated. Thanks, DW
 
Try changing the Name of the text box (Other tab of Properties box) when you
change the ControlSource.

Access gets confused if the control has the same Name as a field, but is
bound to something else.
 
Thank You Very Much !!!!
I was very frustrated.
-----Original Message-----
Try changing the Name of the text box (Other tab of Properties box) when you
change the ControlSource.

Access gets confused if the control has the same Name as a field, but is
bound to something else.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Don Whitaker said:
I am using Accss 2000 to create a report, but I can't
seem to use expressions on my report to any degree of
luck. My report runs off of a query. It looks like
anything that I want a function on or calculate I have to
do it in the query and not in the report on the control
source property. Is that right or am I missing something.
It looks like I cannot use =[PayType] to display a field
on the report?
When I use =[PayType] I get an #Error the function I'm
trying use is UCase I thought the expression should be
=UCase([PayType]), but all I get is #Error, now when I
put in the query expPType:Ucase([PayType]) it works fine?

I am also trying to do minor formatting and string
concatenation, but I guess I have to do it in the query?
Any advice is appreciated. Thanks, DW
Click to expand...


.
Click to expand...
 
Back
Top