How to make access form to math

[Leo]

Hi there! I'm trying to setup my access 2002 form to do
math. I have products in a drop down menu, then to the
right I have a quantity box, then to the right of that I
have a total box. What I would like to be able to do is
set the price for the product (IE blue hat 12.00) and
make it so that in the total box comes the product of the
item x the quantity. I appreciate your help!

Leo

 

[Access]

The Total box should be unbound and = [Price] * [Quantity]

 

[Leo]

thanks for the quick response! I guess my real question
is how do I make the item box Display text to us and a
number to access without confusing the computer? IE

Item = Blue Hat 12.00

To the computer it should only say 12.00 with the text in
there it comes up with an error. So how do i make it
easy for us and easy for the computer?

-----Original Message-----
The Total box should be unbound and = [Price] * [Quantity]

Hi there! I'm trying to setup my access 2002 form to do
math. I have products in a drop down menu, then to the
right I have a quantity box, then to the right of that I
have a total box. What I would like to be able to do is
set the price for the product (IE blue hat 12.00) and
make it so that in the total box comes the product of the
item x the quantity. I appreciate your help!

Leo

.

 

[Access]

Well to make it easy for the computer, divide your item field into [item]
and [price] and then it will work.
Your [item] field could still be a drop-down.

thanks for the quick response! I guess my real question
is how do I make the item box Display text to us and a
number to access without confusing the computer? IE

Item = Blue Hat 12.00

To the computer it should only say 12.00 with the text in
there it comes up with an error. So how do i make it
easy for us and easy for the computer?

-----Original Message-----
The Total box should be unbound and = [Price] * [Quantity]

Hi there! I'm trying to setup my access 2002 form to do
math. I have products in a drop down menu, then to the
right I have a quantity box, then to the right of that I
have a total box. What I would like to be able to do is
set the price for the product (IE blue hat 12.00) and
make it so that in the total box comes the product of the
item x the quantity. I appreciate your help!

Leo

.

 

[Leo]

Is there a way that I can make it so that when I select
an item the price of that item is automatically entered
into a price box next to it? Maybe that would be easier
on the computer.

Ps. I did send you an email as well.

-----Original Message-----
Well to make it easy for the computer, divide your item field into [item]
and [price] and then it will work.
Your [item] field could still be a drop-down.

thanks for the quick response! I guess my real question
is how do I make the item box Display text to us and a
number to access without confusing the computer? IE

Item = Blue Hat 12.00

To the computer it should only say 12.00 with the text in
there it comes up with an error. So how do i make it
easy for us and easy for the computer?

-----Original Message-----
The Total box should be unbound and = [Price] * [Quantity]


Hi there! I'm trying to setup my access 2002 form

to
do

math. I have products in a drop down menu, then to the
right I have a quantity box, then to the right of

that
I

have a total box. What I would like to be able to

do
is

set the price for the product (IE blue hat 12.00) and
make it so that in the total box comes the product

of
the

item x the quantity. I appreciate your help!

Leo


.

.