By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,283 Members | 1,703 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,283 IT Pros & Developers. It's quick & easy.

How to link 2 tables query using calculated fiels

P: 2
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?
Sep 3 '07 #1
Share this Question
Share on Google+
3 Replies


Expert 100+
P: 126
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.
Sep 3 '07 #2

P: 2
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?
Sep 3 '07 #3

Expert 100+
P: 126
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)
Sep 3 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.