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

E

Eve

How do I update a query to reflect changes made on the table? I thought it
would update automatically but it does not.
 
R

Rick B

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.
 
Top