Parametor Query

[ddingee]

I want to query a table and set about 6 parametors, in some cases no criteria will be inputted, but when I run the query with no input data my results are nothing. I want to set several paramtors and where no criteria is entered it will pull records.

 

[adz2013]

Look at the "Wildcard Peramiter Query" quetion on this page. I think you will find your answer there.

 

[ddingee]

I tried your suggestion and am still coming up with no records.

I have a table that stores sales orders and want to create a database where a customer serv. rep can type in what they need in the fields I have set for them.
parametor Fields are:
order type
region
CSR
Customer number
customer name
ship to

there are other fields but the above are the ones I have set parametors for and if they only want to enter a region and leave other fields blank I still get no records.