sum function keeps rounding my currency

[tractorvix]

I have a query that brings back the value of around 145,000 items.

I need to then sum them based on the first 4 characters of the item number.

all fine, except the sum function keeps rounding the currency values so instead of getting £6.15 I get £6.00.

This is driving me mad. I would usually just export to excel and do it there, but I've too many records.

Please help before I throw the whole thing through the window.

Tractorvix

 

[THWatson]

Tractorvix
In your query, right click in the Criteria row, then in the Format row select Currency, and then 2 decimals, and see if that does it.

Tom