Join Stack Overflow to learn, share knowledge, and build your career. Connect and share knowledge within a single location that is structured and easy to search. Is there a way to do it? Normally query used as data source for forms and reports, not directly. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams?
A situation may arise where we need to update many records in a database table when certain information changes or needs to be modified. A Microsoft Access Update Query updates specified values in a table for all records or for those records that match a specified criteria. It is possible to update records manually in a database table, either via a form or through the tables datasheet, however this may take a very long time. Changing records manually is not only time consuming, it is also inefficient, and lends itself to errors as you update the records. The best way to handle this type of event, the updating of many records in a database table, is to use an Update Query to make the changes to data in one operation. You will save yourself time, and eliminate the possibility of manual errors. Note: Due to the permanent effects of working with an update action query, you should always make a backup copy of your tables, or your database before attempting this option.
Aggregate queries are great if you are looking just for one specific number, but if you want summarizing information like a spreadsheet-like summary you might want to consider trying a crosstab query. When you want to restructure summary data to make it easier to read and understand, consider using a Crosstab Query. A crosstab query is a type of Select Query. When you run a crosstab query, the results get displayed in a datasheet. This datasheet has a different structure from the other types of datasheets.
I've already created and tested a select query that displays the desired records to be updated. What is the next step? In Datasheet view, in the Update To cell in the field grid, type the appropriate command to increase the price by 5 percent.