Mulitiple types of searches

[UT227]

I'm trying to have a query run a search from a search box.



My search box: frmStatisticAnalysis
Search Field: cboCampus
Search Field: txtYear

My query criteria:
Campus: [Forms]![frmStatisticAnalysis]![txtYear]
Year: [Forms]![frmStatisticAnalysis]![cboCampusID]

This works great. However, I found out that I need to add a month search to it. I want it to search whether or not that field is populated. If it is populated, I want it to search all three criteria. If the month is not populated, I want it to search just the cboCampus and txtYear.


This is the first search


This didn't work

[pbaldy]

Try this in the month criteria, using the first pic as a start:

http://www.theaccessweb.com/queries/qry0001.htm

[UT227]

Dude, you're awesome!! Been beating my head on a wall over that. It worked great. Thanks...

[pbaldy]

Happy to help!