Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Oct 2002
    Location
    New Salem, North Dakota, USA
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Summing on a report (2000)

    I am having a little trouble when I try to sum a column on a report. It is currency. Access is getting .63 cents and I get .65 cents when I add up the same column. This is just on the report...I am just saying [=Sum([Commod Amt])]
    Does access just takes the amounts that are on the report or is it going further back? Maybe some decimal places are interfering with this...I did go back and check at the tables and I also get a completely different total.....
    Thanks in advance, Kristen

  2. #2
    Lounger
    Join Date
    Jan 2003
    Location
    Herndon, Virginia, USA
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Summing on a report (2000)

    When Access does a calculation in a report, it uses the underlying values from the data source (query or table), not the formatted values that show up on the report. You can force that to happen by rounding the values on the report using a function in a text box (look for a post that describes the best way to round numbers) and then summing the values that text box (makes sure it isn't named the same as the underlying field).

    Brent

Posting Permissions

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