Creating new table columns and maintaining joins in another query

  • Thread starter Thread starter MMC
  • Start date Start date
M

MMC

Hi,

I have a table with alot of account information. However, to report on
certain accounts, I have to manipulate a few of the column data and create a
new column with the correct information.

Once I have this new column, I do another query and get the information that
I need out of that new column.

The problem is when I'm querying from that new column, I'm join'ing that
information to another column of information and it works the way I want it
to work.
But when I get more data, I have to run the original script that manipulates
the data and creates a new column, again. When the new column is re-created
with the new data, the join (arrow) from the other query disappears or gets
lost.

If anyone knows a way for me to update information in the table, but
maintain the join in the other query, please let me know. Or if anyone knows
a different approach to the issue, I'd appreciate the help.
 
When the new column is re-created with the new data, the join (arrow) from
the other query disappears or gets lost.
How are you 're-creating' the column?

Better is just to use a query that does the calculations and join it in the
follow-on query. No need to create a new column in the table.
 
In the query window, I "re-create" the column by double-clicking on the
makeColumn query that I created that constructs a new column in the table.
It is necessary that I construct a new column in the table due to the nature
of the information I need.

Here's the scenario.

I have information that I need to get from a table. However, the
information is not readily available in the table. So I create a query
(Qry1) which results in creating a new column in my table.

There are 2 other queries that I have created. Qry2 pulls information from
the Table and Qry3 pulls information from the column resulting from Qry1.

In the last query (Qry4), I am joining (with an arrow) Qry2 and Qry3.

Everything works fine and I get all the information I am looking for.

The problem is when I need to update Qry1, it creates a new column by
overwriting the old column. Even though all the names are the same, the join
(arrow) gets lost in Qry4.

I hope this is more clear and not so confusing.

Any help is appreciated.
 
Back
Top