![]() If you do not want to change the data in those tables, but would still like to edit the data and keep the edited data after you are finished, you can use a make-table query to first create a new table whose data you can edit. Usually, when you want to edit data in query Datasheet view, you want your changes to be saved to the tables on which the query is based. This article does not cover update queries.įor more information about update queries, see the article Create and run an update query. In addition to editing data in query Datasheet view, you can also use an update query to update data in a table. In either case, you may be able to do something to enable editing. It may also be the case that only the field you are trying to edit is not available for editing - for example, if the field is based on an aggregate function, such as an average. ![]() It may be the case that the query itself is not available for editing, such as a crosstab query. If you try to edit the data in a query datasheet but nothing happens, or Windows plays a sound and your edit doesn't happen, you cannot perform the edit. Depending on how the query was built, you can edit the data directly in the query datasheet. Perhaps you notice an error, or perhaps you see some information that is out of date. When you open a query in Datasheet view, you may find you want to edit the data. How do I change a query so that I can edit its data? This article helps you understand when you can edit query data, when you cannot edit query data, and how to change the design of a query so that you can edit its underlying data. You may encounter situations where you cannot edit data in query Datasheet view to change the data in the underlying table.
0 Comments
Leave a Reply. |