G
Guest
Hi -
I have a form that is linked to a query. I want to take one of the fields
in the form (this field is coming directly from the query), and create a
formula from a field in a different query. Example: The form is linked to
Query 1 - Field 1. I want to create a formula i my form that subtracts Field
2 from query 2. Everytim I try to do this I get the result "#Name?" I
assume I am getting this results because it does not know the association
with Query 2. How can I get this to calculate correctly? Or is it even
possible? Thanks.
I have a form that is linked to a query. I want to take one of the fields
in the form (this field is coming directly from the query), and create a
formula from a field in a different query. Example: The form is linked to
Query 1 - Field 1. I want to create a formula i my form that subtracts Field
2 from query 2. Everytim I try to do this I get the result "#Name?" I
assume I am getting this results because it does not know the association
with Query 2. How can I get this to calculate correctly? Or is it even
possible? Thanks.