how to get total and subtotal in a form and a subform?

  • Thread starter Thread starter may121
  • Start date Start date
M

may121

I created one form : item:item ID, item unitprice....
one form : order:OrderID, ....
one subform: order/item:order ID, item ID, item qty( ordered)....
coz every order has several items, and each items has unique price.

I need to caculate each item amount:[unitprice]* [qty], and total
amount for each order :sum[item amount]. how can I acheive this
function? thanks a lot.

now I am trying to using combo box to add unit price to each item in
the sub form of order/item, but there is a problem. The unit price
can't automatically update to each item. they all appear as one
unitprice.each time I click different item price. then all the field in
the unitprice area will chage to one same price.
 
What is this for? Are you writting your own program to
conduct business? If you are and you are having this
problem I suggest you hire a programmer or buy an account
program. There is so much more to a POS (point of sale)
system and I highly suggest only the well trained attack
it.

Your layout is confusing. Where is the combo box and why
would you use it to add a unit price?

ds
-----Original Message-----
I created one form : item:item ID, item unitprice....
one form : order:OrderID, ....
one subform: order/item:order ID, item ID, item qty( ordered)....
coz every order has several items, and each items has unique price.

I need to caculate each item amount:[unitprice]* [qty], and total
amount for each order :sum[item amount]. how can I acheive this
function? thanks a lot.

now I am trying to using combo box to add unit price to each item in
the sub form of order/item, but there is a problem. The unit price
can't automatically update to each item. they all appear as one
unitprice.each time I click different item price. then all the field in
the unitprice area will chage to one same price.



------------------------------------------------
Click to expand...
 
What is this for? Are you writting your own program to
conduct business? If you are and you are having this
problem I suggest you hire a programmer or buy an account
program. There is so much more to a POS (point of sale)
system and I highly suggest only the well trained attack
it.

Your layout is confusing. Where is the combo box and why
would you use it to add a unit price?

ds
-----Original Message-----
I created one form : item:item ID, item unitprice....
one form : order:OrderID, ....
one subform: order/item:order ID, item ID, item qty( ordered)....
coz every order has several items, and each items has unique price.

I need to caculate each item amount:[unitprice]* [qty], and total
amount for each order :sum[item amount]. how can I acheive this
function? thanks a lot.

now I am trying to using combo box to add unit price to each item in
the sub form of order/item, but there is a problem. The unit price
can't automatically update to each item. they all appear as one
unitprice.each time I click different item price. then all the field in
the unitprice area will chage to one same price.



------------------------------------------------
Click to expand...
 
Back
Top