Expession works in Query But not in Form

[AJJ38]

I have an expression in a query that works fine. But when I build a form off of that query it displays #Name?

I don't understand.

My query takes the is =InvoiceTotal: [Quantity]*[Price Per Item]+[Clear Agent Fee]+[Duty]

And that will work but when I make a form it comes up with #Name?

Any help would be most appreciated

Aaron

 

[cookiegary01]

Try this in the form:
=[Quantity]*[Price Per Item]+[Clear Agent Fee]+[Duty]

 

[AJJ38]

Thank you...can you tell me where I put it in the form?

 

[cookiegary01]

Aaron,
What do you mean where to put it?
Normally one would place it to the right of the fields you mentioned that make up this Invoicetotal.
By the way, if your form is based on the query you mentioned, you would only have to add the field InvoiceTotal form the query into the form.

 

[AJJ38]

Hi Gary,

It is based on the query and works there. Which is why it is so strange it doesn't work in the form...I will try adding the formula to the form. Thanks again for your time

Aaron

 

[AJJ38]

Gary,

I do appreciate your help...it works. Thanks again and I hope to learn enough to give you a hand one day.

Take care,
Aaron