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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Main Form and two Subforms 2
Changing sign of a value in calculated field 1
Need help on how to pass calculated field from a form to another form 0
Copy record info into new form 0
Using DSUM to get running total on a filtered form 0
Continuous Form question 5
How to make a sum of a sub-form on the main form 2

Back
Top