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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Giuliana - 14 Mar 2006 16:58 GMT

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?

Reply to this Message

Rick B - 14 Mar 2006 17:04 GMT

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.

Signature

Rick B

> 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?

Reply to this Message

John Vinson - 15 Mar 2006 02:41 GMT

>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?

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]

Reply to this Message