If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
I wish to assign Quantity the value of [Quantity]-[OrderAmt]
Hello
I have a some related tables (and the relationships work fine on the form) two of the fields are [tblBrochures]![Quanity] and [tblOrders]![OrderAmt], both the fields are "single" and bound I wish to assign Quantity the value of [Quantity]-[OrderAmt] Can you tell me how to do this please? Thanks |
#2
|
|||
|
|||
I wish to assign Quantity the value of [Quantity]-[OrderAmt]
Tony,
Ummm, could be me but I don't get it... Did you mean you want to show the Balance in a Text Box? -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Tony" wrote in message ... Hello I have a some related tables (and the relationships work fine on the form) two of the fields are [tblBrochures]![Quanity] and [tblOrders]![OrderAmt], both the fields are "single" and bound I wish to assign Quantity the value of [Quantity]-[OrderAmt] Can you tell me how to do this please? Thanks |
Thread Tools | |
Display Modes | |
|
|