I mistakenly entered "LQ1-," "LQ2-" and "LQ3-" in certain records in a field to serve as query select markers. Each is followed by a two-digit number for sorting, e.g., "LQ1-01, LQ1-02 ...." They should have been "LQ1a-," "LQ1b-" and "LQ1c- followed by the two-digit number." Fixing this with Edit > Find / Replace should be trivial, but I just started using Base and I can't figure it out. Surely there is a simple way to do this without manually typing a couple hundred changes.
I can open the table, and then Edit > Find allows me to locate the records. But there is no Replace box. I can open a query, but all I can figure out how to do is SELECT. How do I do an UPDATE query? Any suggestions? --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
