Need help making report from query w some equations

[advanced dabbler]

I want to make a report from my query but I need it to do some things I'm
finding difficult. The query contains the following fields:

Practice Date 2 Type of Case Price 1 Price 2

I need to show each practice, sorting by date and then, depending on the
"Type of Case" I need the Case*Price 1 or Price 2 in a text box so that
I can sum the prices by the different case types. Gees, that makes no
sense when I read it, but, it's what I need to do.

Any help??

 

[Marshall Barton]

I want to make a report from my query but I need it to do some things I'm
finding difficult. The query contains the following fields:

Practice Date 2 Type of Case Price 1 Price 2

I need to show each practice, sorting by date and then, depending on the
"Type of Case" I need the Case*Price 1 or Price 2 in a text box so that
I can sum the prices by the different case types. Gees, that makes no
sense when I read it, but, it's what I need to do.

Henerally, you should sum text boxes when you can sum fields
in the report's record source table/query. The latter
allows you to use the Sum function while the former requires
the use of additional text boxed and the RunningSum
property.

To sum prices, you could use a footer section text box with
an expression like:
=Sum(IIf([Type of Case] = 1, [Price 1], 0))

If that's not what you are trying to do, take another shot
at explaining what it is, possibly via a short example.

 

[KARL DEWEY]

Use this calculated field --
Sale_Price: IIf([Type of Case] = 1, [Price 1], [Price 2])