Updating Queries

[Geodon7]

Sorry for the basic question, but I'm not very familiar with queries. Anyway, does a query update on its own (ie. when it's opened or referred to) or do you have to update it? If it needs to be updated 'manually' is there a way to auto-update?

Thanks in advance,
G

 

[cheerio]

A standard select query is basically a request for information.

When you run the query you will get the information based on your selection criteria.

So if you have a database table that shows people, their hometown and occupation and ask for a list of Accountants in Wokingham England you will get such a list.

Access will not update the list while you look at it to reflect the fact that since your query there are more accountants in Wokingham.

If there is other information delivered by the query such as whether their speciality is Audit or Tax and such information changes then Access will reflect that on screen.

If while you watch an accountant changes his occupation to Farmer the occupation will change on screen. Access will not drop that person from view.

So to summarise there are two separate processes.

A query (or requery) goes back to the database when you specifically ask and reselects the data.

A refresh takes the existing data and shows any changes to that data. There can be a short delay before Access automatically refreshes but you can force a refresh at any time.

Ken