Windows 7 64bit 
Access 2010 64bit
So to preface, I am a complete novice at manipulating forms, etc. in a database, nor do I have programming knowledge (I know, oh boy).
I am trying to build a form to filter a query in access 2010. The query is created from several linked tables. I have figured out some simple basics, such as using query criteria (Like "*" & [Forms]![SearchTest]![ChangeType] & "*") to control the query.
There are a few things I want to do, that I think are a little more complex and I am having trouble figuring out.
One is that I have a project field that I want to filter from. If I keep it simple and use the criteria shown above, no problem, but I can't figure out how to filter from several (or all) projects in that field.
For example: The " projects" field are locations in my database table. So I might have several thousand records that the project field is "Missouri", several thousand that are "Tennessee", so on and so forth. Using the criteria above (Like "*" & [Forms]![SearchTest]![ChangeType] & "*"), and only allowing input of one project works great, but if I have to run a query including several of my projects, I'm lost.
Also, while I'm asking, I also have a "last modified" date field that I have put begin date and end date text boxes on my form for the user to search for records between those to dates using the following criteria in the query: Between [Forms]![SearchTest]![BeginDate] And [Forms]![SearchTest]![EndDate]. That works as well as long as dates are entered into the form. I would like the query to still run if there are no dates entered, in case the "last modified" date field from the table is blank.
I have been searching forums and googling this issue for the past several hours and I think I've gotten myself lost.
I have no idea if I've given enough information for any kind of answer to my questions or not. Please let me know if I need to expand on my request.
Thank you,
Kraig
Reply With Quote
Originally Posted by andy49
