How do I update a query to reflect changes made on the table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I update a query to reflect changes made on the table? I thought it
would update automatically but it does not.
 
Not sure what you mean by "changes made on the table". If you change a
record in the table, then run your query it will show the current data. If
you changed the structure of your table (added a field, removed a field,
etc.) then you will have to modify your query to reflect those changes. To
do so, open the query in design-view and modify it.
 
You must log in or register to reply here.

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 Updating inventory levels 0
How to Populate Data from a table to another 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Configuration of WordPress for enabling updates eg plugins and WordPress itself.. 1
Chandging Tables and the form not updating?? 8
my query does not update table 2
How to find out which of my queries use a specific table. 0
Ramifications of Re-Naming queries? 1

Back
Top