ddingee
02-06-2002, 11:47 AM
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
02-06-2002, 11:48 AM
Look at the "Wildcard Peramiter Query" quetion on this page. I think you will find your answer there.
ddingee
02-07-2002, 05:11 AM
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.