rounding a dollar figure

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a price table that I want to increase by a percentage. I don't have
any problem in doing this in a form except I want the results to be rounded
to an even amount. Say a price of 232.00 increased by 20% is 278.40 I want
the amount to be rounded to 278.00. Any help would be appreciated.

Thanks
 
Use an Update query. With any kind of global update, it's
a good idea to either make a backup copy of the table, or
do your update to a temporary field and check it to verify
you're getting your expected result.

Drag your price field to the query grid, select
Query/Update Query. In the Update To: row, enter the
formula:

Round([YourPriceField]*1.2)

HTH
Kevin Sprinkel
 
Back
Top