Is there a way in Microsoft Access to make a quary/macro that will search tables for rows that meet certain preset search conditions. I'm thinking an If/Then or Select Case(if possible in office) statement would be used to set the search conditions.

I ultimately want to be able to search a table/record and if a match for the search is found I want all the data from that row pulled out and put into another table. Is this possible?

Please post Access questions at http://www.accessforums.net/.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]