Need help calculating a percentage

[BigBlueMan]

This SHOULD be simple, but somehow I'm doing something wrong.

I have a report that gives me a list of items and their retail prices. I
want to include a calculated field on the report only that tells me 70% of
the retail price. This figure does NOT need to be part of the database.

I have tried various layouts for the calculation and it never comes out
right.

Thanks for any help you can offer.

Ed

 

[E Hines]

I assume you're having trouble getting a calculated field
onto your form. Try this:

Add a TextBox to your form in an appropriate location.
Select the Properties dialog and the Data tab.
In the Control Source field, add the following:
=Sum([retail price] * 0.7)

Hope this helps.

Eric Hines

 

[BigBlueMan]

Thanks! I was leaving out the SUM part. I'll go try it!

ed

I assume you're having trouble getting a calculated field
onto your form. Try this:

Add a TextBox to your form in an appropriate location.
Select the Properties dialog and the Data tab.
In the Control Source field, add the following:
=Sum([retail price] * 0.7)

Hope this helps.

Eric Hines

-----Original Message-----
This SHOULD be simple, but somehow I'm doing something wrong.

I have a report that gives me a list of items and their retail prices. I
want to include a calculated field on the report only that tells me 70% of
the retail price. This figure does NOT need to be part of the database.

I have tried various layouts for the calculation and it never comes out
right.

Thanks for any help you can offer.

Ed


.