ROUNDING QUESTION

  • Thread starter Thread starter WWV
  • Start date Start date
W

WWV

I have a query (Access 2003) and I calculate a field ie.
([2001 af can]-[tot fee can 30])-[adjustments to billing]+1750 I want to
round this result and still have two decimal places. Any help appreciated.
WWV
 
Try:
Round(([2001 af can]-[tot fee can 30])-[adjustments to billing]+1750, 2)

If some of these values could be Null, you may need to use Nz() to supply a
zero for that part. Further, you might like to ensure Access understands the
result as currency to avoid this problem:
Calculated fields misinterpreted
at:
http://members.iinet.net.au/~allenbrowne/ser-45.html

So the calculate field would become:
CCur(Round(Nz([2001 af can],0) - Nz([tot fee can 30],0) - Nz([adjustments to
billing],0) + 1750, 2))
 
Back
Top