attached is a template "search4" which allows one to search a db by a combination Text(*), and Number(<=>), selections.. up to 3 fields.
So a 3 variable search/filter with a Report Generating option.
It does so with VBA and a little SQL by allowing the user to select the Catagory (field)...