hi
the guts of Microsoft Query (MSQ) is ODBC and the language behind it is SQL.
it is just conveniently packaged as a MS Wizard ie point and click.
can you say the words "recorded macro"?
tell us more about this "searching keywords is pretty cumbersome" so that
we might better understand what the problem is and perhaps what you are
trying to accomplish?
regards
FSt1
If you copied and pasted (or exported the contents of a DB table) into
an Excel spreadsheet, you'd have 1000 records with a lot of various
text populated in the fields and want to find only the word
"FSt1" (and only have those instances show up in the MS Query). One
other way to do this would be to use the Ctrl F key and 'find' your
way through the various records but I'd hoped to get something similar
to what you might find when you *filter* info which seems a bit more
straight forward. This is actually a MySQL DB table by the way and
the SysAdmin is concerned over what might happen if someone were
writing to the DB table when a query were being run so is inclined to
ask that the data be exported to an Excel spreadsheet and used or
manipulated from there.