I have an update query that updates one field "Total" by multiplying "Price" by "Quantity".
The problem with this is the result is rounded off to a whole number, so when an item costs £2.50, 3 are bought, the total is rounded up to £8.00 which is not good. The Price field is set to Double size...