How do I insert an expression in a Access report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I keep getting the "you have a syntax (comma) error" message and when I
trouble shooting the formula. I have put a basic expression in a Report and I
do not know whether I am asking Access to do something it can not (i.e. put
an IIf expression in a report) or if there is actually an error with my
formula.
 
Ineedhelp said:
I keep getting the "you have a syntax (comma) error" message and when I
trouble shooting the formula. I have put a basic expression in a Report
and I
do not know whether I am asking Access to do something it can not (i.e.
put
an IIf expression in a report) or if there is actually an error with my
formula.
Click to expand...

As you haven't shown us the formula in question ... neither do we! :-)

In general terms, though, if you have fields in the report's recordsource
named "Value1" and "Value2" (not terribly good names, but this is just an
example) then the following expression should work in the ControlSource
property of a text box in the detail section of the report ...

=[Value1] + [Value2]
 
Back
Top