Form calculation - Simple question

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Yes, base your form on a third query that includes the other two queries and
draw the relationship.

In other words, your form's data source needs to include the two fields you
wish to reference in your formula.

--
Rick B



"Send Object Command - Two attachments"
 
Back
Top