Expressions in Reports

[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?

 

[Arvin Meyer [MVP]]

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

 

[Guest]

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.

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 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?

 

[Guest]

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.