I REALLY REALLY appreciate any help that anyone can offer.
I have a table called Data with the following fields:
1) ID
2) ReportDate
3) Department
4) DepartmentNumber
5) AccountExecutive
6) 7 yes/no fields
7) 6 memo fields
I would like to have a form created where I could look up various values based on different criteria. Should be pretty simple, but I'm VERY rusty at access at the moment, it's been a few years since I've had to really use it like this. Anyway.. I would like to have something like buttons created so that I can click on them and be prompted to enter fields, mainly dates.
I want to be able to look up the following:
Records from Date to Date
Records before a certain Date
Records after a certain Date
Records of a specific Department from Date to Date
Records of a specific Department before a certain Date
Records of a specific Department after a certain Date
I can manage the first of these, like the Date to Date (the only reason why I've included them was to see if there is a better or more efficient way of doing it), but I'm having trouble with using 2 criteria to look up old records, mainly the fact that I have to select a specific department and then look up the date. I'm not sure how to filter? that so that I get specific departments and then am able to type the date in and get records for certain dates for that department that is selected only.
Should I use a dropdown with departments listed so that after I select a department and click a button I will be promped to enter dates for a specific time based on that department? Should this be done in a query, and if so, how do I like that query to the form so that I can select a specific department?
Thanks in advance for any help