How do I multiply one field by another in Access?

G

GolfNut

How do I multiply one field by another in an Access query? One field is
Units on Hand with multiple numbers and the other field is price per unit.
 
C

Chaim

SELECT [Units on Hand], [Price Per Unit], [Units on Hand] * [Price Per Unit]
FROM [Your Table];

Be aware of NULLs!
 
S

Steve Schapel

GolfNut,

Make a query based on your table. In the query design grid, make a
calculated field as follows... In the Field row of a blank column, put
the equivalent of this:
NameForCalculatedField: [Units on Hand]*[price per unit]
 
T

Tristesse

I just wanted to say thanks to Steve for posting those instructions. I was
having problems getting a calculated field to work, but when I read Steven's
instructions I realised what I was doing wrong. THANKS!!!
 
Top