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.
JohnSUN - Thank you so much - yes that does exactly what I wanted!
It makes SQL-command
UPDATE "Test" SET Y5='XYZ' WHERE Y5='ABC'
JohnSUN - Thank you so much - yes that does exactly what I wanted!
I guess I need to go through some SQL tutorials and learn the language and syntax. Previously (a long time ago) used Paradox and as I recall these kinds of commands were mostly built in to the query structure with a relatively simple UI.
Thanks so much for the great visual. That really helps!!