Expressions in Reports

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

Guest

I am using Access 2000 and I am trying to create a profit & loss report. I
have several line items grouped together to give me summaries. I cannot
figure out how to calculate the profit on the report. I need an expression
that will take the total sales group and subtract out the total expense
groups. Can anyone help?
 
In the report footer use the following expression as the controlsource of a
textbox:

= Sum([Sales]) - Sum([Expense])

of course substituting your field names. Remember it's in the report's
footer that you need to do this.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
I receive a prompt for a parameter query when I enter this formula. Can I
use the group names with this type of formula. In my case [Sales] and
[Expense] are group names.

Arvin Meyer said:
In the report footer use the following expression as the controlsource of a
textbox:

= Sum([Sales]) - Sum([Expense])

of course substituting your field names. Remember it's in the report's
footer that you need to do this.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

Crystal said:
I am using Access 2000 and I am trying to create a profit & loss report. I
have several line items grouped together to give me summaries. I cannot
figure out how to calculate the profit on the report. I need an expression
that will take the total sales group and subtract out the total expense
groups. Can anyone help?
Click to expand...
Click to expand...
 
You must use the names of fields from the table or query that is the
recordsource for the report, representign the DETAIL amounts of sales and
expenses.
 
Back
Top