|
| 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
March 30th, 2010, 03:25 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Calculated fields on a form
Hello
I have a series of related tables (and the relationships work fine on the form) and I am trying to do a calculated field on a form : I have added a textbox and built the formula =[tblBrochures]![Quanity]-[tblOrders]![OrderAmt] both the variables are "single" But I get an error #Name? returned. ideally i would like to have the Quantity assigned the value of [tblBrochures]![Quanity]-[tblOrders]![OrderAmt]. Can someone please help? 
|
|
#2
March 30th, 2010, 04:09 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Calculated fields on a form
Are both of those fields, [Quantity] & [OrderAmt], bound to your form?
If so, you can just omit the table names altogether. =[Quantity] - [OrderAmt]
|
|
#3
March 30th, 2010, 04:51 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Calculated fields on a form
Assuming that both fields are already on the form or part of the form's
record source: =[Quanity] - [OrderAmt] -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Tony" wrote: Hello I have a series of related tables (and the relationships work fine on the form) and I am trying to do a calculated field on a form : I have added a textbox and built the formula =[tblBrochures]![Quanity]-[tblOrders]![OrderAmt] both the variables are "single" But I get an error #Name? returned. ideally i would like to have the Quantity assigned the value of [tblBrochures]![Quanity]-[tblOrders]![OrderAmt]. Can someone please help?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
