Update Query in MS Access - Office 365

preview_player
Показать описание
Update queries in MS Access are used to add, change or delete information in an existing record. You can not use an update query to add new records or to delete records from a database. An update query is a type of action query that makes changes to several records at the same time. As a best practice when creating an update query first create a select query that identifies the records that you want to update then convert that query to an update query that you can run to update the records. This will help to avoid making incorrect updates to records. You can use any expression with an update query, ranging from mathematical functions to string operations.
Рекомендации по теме
Комментарии
Автор

Awesome 👌
Question
How do I associate form filtering with update query filtering? So that it updates the records that were selected by the form filter ? 🙏🏼🙏🏼🙏🏼

ssdusd
Автор

what if I wanted to get the criteria from another table

PiyushSharma-bxpm