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?