Rounding numbers

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I have an Access 97 database and I need to round numbers
to the nearest penny. This is crucial as it is a currency
field that I need to round and it is causing accounting
problems. Yet as far as I can see there is no ROUND
function in Access 97. How can I round the numbers??

Thanks if you have an answer!!

Mark
Ontario, Canada
 
You will find a sample rounding function at the link below. I would
recommend renaming the function to MyRound or something other than it's
current name. It was written before Access 2000 which has a function named
Round. Renaming this one may save you problems if you upgrade the file to a
newer version later.

http://www.mvps.org/access/modules/mdl0054.htm
 
Back
Top