Simple question...hopefully

[Mambozzy]

Alright, I've designed a database to be as user-friendly as possible. Currently, I have a button to run a parameter query and put it all on a report. There are three variables (school, city, ASVAB score) and the user must have the option to use all, none and some of the 'filters'.
I have the whole "criteria: [name of school:], Or: Is null" code in and it will work if I enter perameters for every field and it will show all entries if I enter no parameters. However, if I enter one parameter and leave another blank, I recieve no results and for the life of me can't figure out why. Please help.
-Oz

 

[Marcs41]

I guess you are using Access (wasn't specified).
I suggest you repost this question in the Access Forum, you will get alot more responses.
forum181 If the solution is here, let us know it was helpful so others can benefit from it as too

 

[xlbo]

Probably the way you have set up the parameters. at a guess, you are in design view and have set up the parameters as an AND parameter set - ie all parameters on thye same line. You may need an OR combination which requires that the parameters be on seperate criteria lines Rgds
Geoff

Vah! Denuone Latine loquebar? Me ineptum. Interdum modo elabitur