I have a form which is used to search my main table based on criteria like Name and Group and return the results in a subform. In addition to Name and Group columns, I currently have 3 columns in my table which represent modules of a system. When users are trained on the modules, I put the date that they were trained into that field. At this time, I can search for specific dates, but I also want to search by date ranges.
Is it possible to have date range Search Textboxes and a checkbox to select which Module column I want the search to apply to?
For a Date Range search, do I have to use separate textboxes for startMonth, endMonth, startYear and endYear, or can I do a startMnthYr, endMnthYr?
Especially if I have to do the months and years separately, I need to have a check box system for choosing which module column to search.
Any help is greatly appreciated!
Silvia