Update a query with new data

  • Thread starter Thread starter Charles Deng
  • Start date Start date
C

Charles Deng

Hi All:

I want to update a query with a set of new data. Every
thing, such as query format and reports for this query, is
the same. Could anyone tell me the steps I need to go to
complete this updating? Thanks a lot.


Charles
 
Hi All:

I want to update a query with a set of new data. Every
thing, such as query format and reports for this query, is
the same. Could anyone tell me the steps I need to go to
complete this updating? Thanks a lot.


Charles
Click to expand...

See my answer in the other thread. You don't need to "update" a query;
the data in a query has no independent existance, it's just pointers
to data which exists in Tables. If you update the table, a query based
on that table is ipso facto already updated.

John W. Vinson[MVP]
(no longer chatting for now)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access macro 1
Update query issue 0
How to update data in a query 1
Update primary key field with multiple "where" clauses 0
Access #Error & Excel Pivot 0
Select, update query--same query, different result 7
Update Query using Table & Query 3
Update query 1

Back
Top