By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,281 Members | 1,802 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,281 IT Pros & Developers. It's quick & easy.

adding fields together and multiplying in access 03

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a

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

P: n/a
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.