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]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#Error in Expression 2
Expression in Access "Reports" 2
expression builder NOT 1
IIf in a report based on select query -- problem w/parameters 2
Access Access database invalid syntax error message 0
How do I use the & character in an Access Report Header? 1
I can't open a report because an expression/macro can't be found 5
Conditional Footers in a report 16

Back
Top