Strange problem with Sum function!?

Chrisopia

Registered User.
Local time
Today, 01:38
Joined
Jul 18, 2008
Messages
279
I have a column (Price) with £10,£20,£30 in 3 seperate records.

I use Sum([Price]) which should return £60
but I get £180... which I realised for some reason the total is multiplied by the number of records.

For instance £20,£30 should give £50... but it doubles it to £100

Why is this happening?
 
Is this the only table in the query?
 
Yup. I am summing up many things in the same query though, Sum([Price]), Sum([Discount]), Sum([VAT]) etc... I just figured that if I make each one it's own query, then use a query to string them all together into one big query.

Very messy but it works.

I still dont understand why it would do that though
 

Users who are viewing this thread

Back
Top Bottom