Macros in query?

[KindleFire]

I am new at this and have seen this done and would like to add this to my query or mayber I am wrong. I would like to apply a filter based on text typed in by user on a query I have already established. Say qryVeh1 i have a list of vehicles, however i want to filter all license plates that have a Z in them and I want to filter another field at the same time for Blue cars. But each time I filter I would like to be able to specify the search criteria without making a ton of queries....Any suggestions?

 

[Chris RR]

Look up parameter queries in the Access help, and then look up wildcards. You want to create a parameter query that uses wildcards.

 

[KindleFire]

I did it way different using a =SetFilt() code through the modules mode and it worked of a form....Thanks though