Relationship with calculated field

[analyst]

In my query, I created a calculated field that will populate the rightmost data of 4 different columns.

I am trying to add in an additional column that will reference this new calculated field and pull data from another table. How do I create a relationship with this calculated field? Since it was manually added by me, it is not a part of a table or query. I tried making a make-table query and got it into its own separate table but when I put that table into my query, the calculation slows down too much.

I'm not sure if this makes any sense. I'm new to access (using it for only 1.5 months) with no prior programming experience.

 

[jzwp22]

I do not think that using a calculated value would every be good to use as a key field. In fact, in most circumstances, calculated values should not be stored in a table at all (just calculated on the fly when you need it in queries, forms or reports).

We need to get a better understanding of your table structure and how the database will be used and what type of data you intend to capture in the database.

 

[analyst]

Nevermind. Thanks for the feedback. I'll keep that in mind. But I figured out a way to get the result I wanted. I had to create several more individual queries and tables to get what I needed.

 

[jzwp22]

OK, glad to hear that you were able to come up with a solution