rounding up when i dont want it to!

[iso96]

Hello,

I ve performed a query on a table and now have a set of results which is fine for example £1.56, £1.98, £87.90 (ive set the values in to a currency format), now i want to calculate the total so i have run another query on the last and used 'sum' in the 'total' this calculates the value but rounds it to the nearest integer for example 91!

the thing is i have done this many times before and havent had this problem! i cant understand it, its seriously doing my head in. Ive tried allsorts including the 'round' function which doesnt alter it.

any help would be appreciated

thanks

iso

 

[Pat Hartman]

Sounds like the sum field is defined as an integer. It should be currency or double.