Results 1 to 2 of 2

Thread: Rounding

  1. #1
    Join Date
    Apr 2003
    Posts
    3

    Unanswered: Rounding

    I need to round a calculation result, can someone tell what I need to do?
    This is what I'm using:

    =IIf([ShipRegion]="PA",CCur([Line Amount]*1.06),"0")

    But I'm getting more than 2 decimal places and it does not seem to be rounding correctly.

    Thanks in advance for your help!
    Amedeo

  2. #2
    Join Date
    Oct 2001
    Location
    Chicago
    Posts
    440
    Did you set the control's format to Currency (which defaults to 2 decimal places)?
    Matt

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •