Need help making report from query w some equations

  • Thread starter advanced dabbler
  • Start date
A

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

Marshall Barton

advanced said:
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.
 
K

KARL DEWEY

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top