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) in a drop down, which once selected sets the parameter options for the search which they can chose between.. Like ">,<,=" if the field is numeric, or "contains" if its text.
works great... BUT...
BUT..
I need to be able to also search/filter by DATE "Before, After, On".
I have tried to modify the template form to work in such a way and tried a number of methods or syntax to acheive this. To no avail. I believe that perhaps another SQL command is required to identify DATES and then integrate them into the commands after the FIELD variable has been selected.
But with little to no SQL in VBA experience I'm not sure what it is.. I have some (very little,.. a few small projects) VBA experience.
In my modified version of the template, I noted where I had made changes. I did add the appropriate fields on the actual form, as well as DB I believe..
I would really REALLY appreciate help on this..
If someone could get the DATE variable working and be kind enough to jot down a basic explaination of how you did it,.. I will ,.. uh.. ummm.. ??? be really greatful?..
THANKS>>>>>>>
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) in a drop down, which once selected sets the parameter options for the search which they can chose between.. Like ">,<,=" if the field is numeric, or "contains" if its text.
works great... BUT...
BUT..
I need to be able to also search/filter by DATE "Before, After, On".
I have tried to modify the template form to work in such a way and tried a number of methods or syntax to acheive this. To no avail. I believe that perhaps another SQL command is required to identify DATES and then integrate them into the commands after the FIELD variable has been selected.
But with little to no SQL in VBA experience I'm not sure what it is.. I have some (very little,.. a few small projects) VBA experience.
In my modified version of the template, I noted where I had made changes. I did add the appropriate fields on the actual form, as well as DB I believe..
I would really REALLY appreciate help on this..
If someone could get the DATE variable working and be kind enough to jot down a basic explaination of how you did it,.. I will ,.. uh.. ummm.. ??? be really greatful?..
THANKS>>>>>>>