I have a table that contains text fields. I can make a query to select the desired records with standard query syntax. I am now looking for a way to set those fields to a specific value.
Example: Change a field called Y5 from a value of ABC to XYZ
I can do this manually (and slowly) using a form entry but would like to find a way to do it via a query.
Any suggestions would be appreciated.