How to link 2 tables query using calculated fiels

[mrcerny]

I am fairly new to Access so this might be pretty easy. I have a calculated field in a query. I would like to link another table to this query through this calculated field. Can anyone help?

[Stwange]

I am fairly new to Access so this might be pretty easy. I have a calculated field in a query. I would like to link another table to this query through this calculated field. Can anyone help?

In your query design window, right click and select "Show Table" (or something similar), add the table you are interested in, then left click on the field you want to link and drag it to the field you want it to be linked to.

[mrcerny]

In your query design window, right click and select "Show Table" (or something similar), add the table you are interested in, then left click on the field you want to link and drag it to the field you want it to be linked to.

Thanks! I know how to do this. But how can I do this when the field is just calculated (not part of another table)? Should i created a new field in the original table? How?

[Stwange]

Thanks! I know how to do this. But how can I do this when the field is just calculated (not part of another table)? Should i created a new field in the original table? How?

There are two options I can think of:
Use nested queries, and in a new query refer to that table and the calculated field from this query, and join them there.

Or (probably better, depending on your field):
Refer to the table only, but where you import the primary key (or whatever field you want to match), have the criteria as:
=(whatever your sum is)