Need help calculating a percentage

  • Thread starter Thread starter BigBlueMan
  • Start date Start date
B

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
 
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
 
Thanks! I was leaving out the SUM part. I'll go try it!

ed


E Hines said:
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


.
Click to expand...
Click to expand...
 
Back
Top