Right now I have just one table in Access which holds different information for colleges. Some of the fields include the tuition and the state in which it is located. I created a form off of this table that allows me to select any criteria of those fields and run a query to get the related results. For example, I can search by schools in New York that cost 30k and get a list of all associated colleges. I do this by creating a query and having the criteria equal whatever value was selected in the form for both of those properties.
However, I need some guidance in setting up how to do the same filter of only one of the fields is filled in. So if I want to not select a state but get all schools costing 30k, how can I do that. The only way I can get it to work is selecting a value for both fields. By leaving one blank my query does not return anything. Eventually this will expand to have four or five filters so I would use this knowledge to do same setup if 1,2,3,4 or all 5 filters are used.
Thanks for any help, if you have any questions let me know.