how do you multiply fields (1 Viewer)

[Cam D]

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.

 

[RainLover]

Simple Math.

([in stock]-[current stock])*[overdue cost]

 

[namliam]

The key here is the math rules!

Muliplying happens before substracting, thus you get 10 - 35 = -25

Look up your math rulez to solve your problem (or use brackets () )

 

[DCrake]

I always remember the acronym BODMAS

Brackets Outside Division, Multiplication, Addition , Subtraction. Maths uses the following order when calculation unbracketed formulae.

David