Expressions in a report

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

Guest

I have a report with a sub report. The report contains a "Total" figure
which comes from the sub report. In another field on the report, I have to
take this figure subtract 8000 and multiply it by 15%. I cannot get an
expression to work out. Does anyone have a suggestion?
 
Ronnie

Please provide the expression you've been using. What about it doesn't
"work out"? Are you getting error messages?

Regards

Jeff Boyce
<Office/Access MVP>
 
This is one of the expressions I've tried =Child320.Report!([Amount Grand
Total Sum]-8000*.15)

And, yes, I am getting an Error message.
 
Ronnie

We're not there. We can't see your PC. We can't see your Error Message.
If you want specific help/suggestions, provide specific information.

By the way, what are you trying to do with "Child320.Report!..."? Again,
not being there means we don't know what you're referring to.

Consider describing what you want to accomplish, in terms an 80-year old
grandmother would understand. Leave out any references to "how" you've been
trying to do it in Access. A more generic notion of where you're trying to
get to might help.

You might also take a look at Access HELP re: expressions in
subforms/subreports. The syntax is fairly complex.

Regards

Jeff Boyce
<Office/Access MVP>

Ronnie said:
This is one of the expressions I've tried =Child320.Report!([Amount Grand
Total Sum]-8000*.15)

And, yes, I am getting an Error message.


--
Ronnie


Jeff Boyce said:
Ronnie

Please provide the expression you've been using. What about it doesn't
"work out"? Are you getting error messages?

Regards

Jeff Boyce
<Office/Access MVP>
Click to expand...
Click to expand...
 
Back
Top