Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Posts
    34

    Unanswered: Display number as a positive in a report

    Hey All,

    What I need to do is display all the numbers on the report as positive but if they belong to a certain grouping they must be subtracted from the grand total.


    My report is pretty simple. The underlying queries are pretty complex. So I would rather alter the report (if possible) than mess around with my queries.

    Any help would be appreciated.

    SD

  2. #2
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    create a box that calculates the absolute value. The control source should be something like:

    =abs(numThatIsSometimesNegative)

    Or you could change your format property ... 0.0;0.0;0.0
    but if you show all positive numbers, then any totals at the bottom cannot be verified using the paper report and a calculator...

Posting Permissions

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