i would like to know how to multiply fields well more to the point i would like to know why this sum comes up with the wrong answer i'm using an update query
[in stock]-[current stock]*[overdue cost]
for the first record it the sum would be 10-7*£5.00 which should equal £15.00 but instead it comes up with -£25.00.
[in stock]-[current stock]*[overdue cost]
for the first record it the sum would be 10-7*£5.00 which should equal £15.00 but instead it comes up with -£25.00.