How do I subtract two different fields that r in different tables

G

Giuliana

im new at access and im trying to subtract to fields that are in different
tables and im getting errors even when I put Forms![Name of the forms][Field]
what im doing wrong?
 
R

Rick B

Well, you don't tell us where you are doing this. What is your record
source? If this is in a Form or Report, just make sure that other table is
in the data source and then you can use fields from that table in your
calculations.

In your example, you say you put... Forms![Name of the forms][Field]
If you are trying to pull a value from a table, then why are you using the
control from a form in your example?

You say you are getting errors, but you don't tell us what they say.

DETAILS PLEASE.
 
J

John Vinson

im new at access and im trying to subtract to fields that are in different
tables and im getting errors even when I put Forms![Name of the forms][Field]
what im doing wrong?
Click to expand...

Let's say TableA has 23188 records. TableB has 9815 records.

Which record in TableA should be subtracted from which record in
TableB? How can Access tell?

Your Forms reference has NOTHING to do with doing calculations between
two tables. What is the Recordsource of the form?

Please explain the context, and indicate how you are attempting to do
the calculation; as posed, your question simply cannot be answered.

John W. Vinson[MVP]
 
Top