Update Query will not persist

[Guest]

I am running an update query which updates a number of fields and would like
to re-use this frequently as I get new data in that needs to be processed. I
assumed that by moving the new data into the table referenced in the query
(and moving the previously processed data out) I could just re-run the update
query to process the new data. I find that after I have run the query,
closed it and then reopen the query my update expressions are gone. I have
been changing it back to a selecte query to view the results and then closing
it. It seems like closing it as an update query may fix that. Is that true?
Is there any other safer way to make the update expressions persist? I
doubt that I will always remember to close it as an update query.... Am I in
the right ball park?

 

[Guest]

When you change a query's type, it changes the underlying SQL. When you close
it and save it, it will retain the current type, but only when you save it.

Can't you close it without saving it?

Barry

 

[Guest]

Barry has pointed out the problem.
If what you are trying to do is see the results after the update query has
run, rather than change the query type, create a select query to review the
results. To make it easy you could create a Macro that will do it all.
Actions in Order:
Delete Old Data (A delete query to delete the old data from the tabe)
Load New Data ( Don't know where you get the data, but you will need at
least an
append query to put the new data in the table)
Update Query (Run your update query)
Select Query(Open the query so you will be able to view the results)

 

[Guest]

Thanks to both of you. You made my day....