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?
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?