Prev: Still stuck: rerunning a query to change criteria
Next: Lock only updated record
From: Tony on 30 Mar 2010 10:25
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?

From: ghetto_banjo on 30 Mar 2010 11:09
Are both of those fields, [Quantity] & [OrderAmt], bound to your form?

If so, you can just omit the table names altogether.

=[Quantity] - [OrderAmt]



From: Jerry Whittle on 30 Mar 2010 11:51
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?
>
 | 
Pages: 1
Prev: Still stuck: rerunning a query to change criteria
Next: Lock only updated record