Make Table Query; Update Query

[jwoo251]

I have a make table query called "ABC". I run the query and it makes "ABC" table.

Then I ended up creating additional update queries that either update/add additional columns to table "ABC". The problem is that everytime I run the "ABC" make table query, the update queries no longer work.

The update query fields turn from the field names into "Expr1". Is there a work around to prevent this???? Any direction one could provider would be greatly appreciated.

(I would be able to make a query then link the addtional tables to this query but would prefer to update the table)

 

[jwoo251]

I just noticed the make table query actually erases the addtional columns I have added.

 

[giacomo]

I can't recall ever having the exact problem you're having but it may be related to the fact that the existing table is being deleted and replaced by the new ABC table causing the field associations in the other query to get broken.

Another option might be to replace the make table query with a delete query and an append query. Run the delete to drop all the existing rows and then the append to populate the table with the new data.


hth,
Giacomo

 

[jwoo251]

Thank you for the suggestion. It worked for what I needed and now I don't need to redo every query. Saved me a good amount of time. thanks again.

 

[giacomo]

I must have been typing when you posted that it was working (slow typer). Glad you figured it out.

Giacomo