Report from Query

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

I have a database that holds amounts classed as 0 & of negative value
(-£1256.00) . I have created a query and set the Yield criteria to >0 and it
ignores all values of less than £1, but when I use a report based on the
query it includes in =Sum([Settlement Yield]) the figures less than zero in
the total. The total should be £40,008.03 but it adds on negative values and
I end up with £42125.83.

Any Ideas?

Bruce
 
I would view the datasheet of the report and select & copy the column to the
clipboard. Then, open Excel and paste the values. Use the =Sum() function to
test your data.
 
Back
Top