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 and Currency format. Quantity is an integer field
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 and Currency format. Quantity is an integer field
