467,920 Members | 1,097 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,920 developers. It's quick & easy.

adding fields together and multiplying in access 03

jho
hello,
I have a pricing sheet form and have the following fields in one row:
SKU
DESC
UNIT PRICE
QTY
PRICE

I want to select the sku in the form and have the corresponding desc
and unit price fill in automatically and then manually input the qty
and have access multiply the unit price field and qty field together
for a total price. How do you do this?I'm not very familiar with
programming. jho

Oct 13 '06 #1
  • viewed: 3833
Share:
2 Replies

jho wrote:
hello,
I have a pricing sheet form and have the following fields in one row:
SKU
DESC
UNIT PRICE
QTY
PRICE

I want to select the sku in the form and have the corresponding desc
and unit price fill in automatically and then manually input the qty
and have access multiply the unit price field and qty field together
for a total price. How do you do this?I'm not very familiar with
programming. jho
make the SKU a combobox, make the combobox have 3 columns, and include
the Desc and Unit Price. Then set the price = cboSKU.Columns(2) *
me.txtQty

Oct 13 '06 #2
jho
ok so all three fields display now (sku, desc, price) using:
SELECT [Table6.ID], TRIM([Table6.SKU] & " " &[Table6.description] & " "
& [Table6.price]) AS PRICE1 FROM Table6;

How do I multiply just the price portion of this with the qty field in
my table? I now have a field called total price. I think I would
populate this fields default value with something right?
pi********@hotmail.com wrote:
jho wrote:
hello,
I have a pricing sheet form and have the following fields in one row:
SKU
DESC
UNIT PRICE
QTY
PRICE

I want to select the sku in the form and have the corresponding desc
and unit price fill in automatically and then manually input the qty
and have access multiply the unit price field and qty field together
for a total price. How do you do this?I'm not very familiar with
programming. jho

make the SKU a combobox, make the combobox have 3 columns, and include
the Desc and Unit Price. Then set the price = cboSKU.Columns(2) *
me.txtQty
Oct 13 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

12 posts views Thread by tjmoses | last post: by
6 posts views Thread by Mangler | last post: by
14 posts views Thread by ap.sakala | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.