Rounding fractional amounts

[Chris C]

A form works out the net and vat amount from the gross. Mostly this is
expressed as a fractional amount, because as whole numbers often loose a
penny or gain a penny here and there. I export my table containing the
fractional amounts to a text file, but unfortunately the amounts after
0.00xxx are truncated.

Is there a any way to round the amounts in a table? The field has to be
General Number (not currency). The table is created and filled in using
create and append queries.

 

[Hugh O'Neill]

Depending upon your Access version, a rounding function is included
in A2000 and greater. You can run an update query to round to 2 (or
any other number) places. There is also rounding function on the
Access Web:

http://www.mvps.org/access/modules/mdl0054.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Adding to what Arvin says, you must be very, very careful to abide
precisely to the rules governing how rounding is to be done for VAT.
These rules are set out in the VAT regulation booklets from Customs and
Excise. If you don't follow the rules correctly and consistently, you
or your trading client could be in deep **** when the VAT inspector
does his audit!

hth

Hugh