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

[may121]

I created one form : item:item ID, item unitprice....
one form : order:OrderID, ....
one subform: order/itemrder 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.

 

[ds]

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/itemrder 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.



------------------------------------------------

 

[ds]

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/itemrder 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.



------------------------------------------------