Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2012
    Posts
    68

    Unanswered: round up/down decimal places in query

    So i have this code in one query field:
    Code:
    Taxed Totals: IIf([items for job transfer]![tax status]="t",[totals]*1.06,[totals])
    Then this in another:

    Code:
    506: IIf([class]="2",[taxed totals],"0")
    The properties pane only gives me an option for decimlas on the first expression. I need to get the decimals down to 2 on the 2 expression. What gives??

  2. #2
    Join Date
    Mar 2012
    Posts
    68
    That quick. I figured it out. It was the "0" in the second expression. I used "null" in its place.

  3. #3
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    FYI, you could probably also have used 0. The quotes made it get treated as text. You can probably also use the Round() function if appropriate to your needs.
    Paul

Posting Permissions

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