I witnessed a cardinal sin of one person manually editing the same value across multiple records instead of using one of Microsoft Access queries well known action query; the update query. Take a quick look at this preview video which is seven minutes long and covers the essentials (and ignore the title with reference to programming in 2013 – not applicable here). In this video, the author mentions the exact match (in double quotations marks) when setting the criteria as […]

Tags: how to change values using queries, microsoft access queries, MS Access Query, ms access update query, working with update queries in access