income statement

[robert]

Hi,

I wonder if someone can help me

I have a table with sales and expenses, the sales have
negative signs and the expenses positibe signs.

In order to create an income statement I have switched the
signs in a query so that the sales are positive and the
expenses negative.

The sales subtotals come up ok, but the expenses need to
have a positive sign but they need to be deducted from the
sales in order to get the true profit or loss.

I would be able to switch the signs of all in the query
but how do I get the report to deduct the expenses from
the revenue if all have the same sign?

If anyone has this answer I would really appreciate your
input.

Thanks,
Robert

 

[Duane Hookom]

You stated "so that the sales are positive and the expenses negative" and
then "but the expenses need to have a positive sign". I don't understand
this. Is there another field that suggests if a record is an expense or a
sales? What's wrong with just using -1*[Your field]?

 

[Marshall Barton]

I have a table with sales and expenses, the sales have
negative signs and the expenses positibe signs.

In order to create an income statement I have switched the
signs in a query so that the sales are positive and the
expenses negative.

The sales subtotals come up ok, but the expenses need to
have a positive sign but they need to be deducted from the
sales in order to get the true profit or loss.

I would be able to switch the signs of all in the query
but how do I get the report to deduct the expenses from
the revenue if all have the same sign?

You're right, Page Break controls (and Page Header/Footer)
are inoperative in subreports. However, you can use a
subreport section's ForceNewPage property in. (KeepTogether
may also help out here.)

If you can strategically place the subsubreports in sections
in the subreport, then ForceNewPage should take care of the
problem.

If you don't have enough sections to do that, create
additional group header and footer sections by using Sorting
and Grouping to group on a constant expression such as =1.

 

[John Cello]

Robert:

I think a better way of doing this would be to just enter
the dollar amounts in both tables as positive. Then,
subtract the expenses from the sales to get your profit.

Hope this get you what you need.

John Cello
John Cello Consulting
Communications For Business
www.johncelloconsulting.com