By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,640 Members | 2,279 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,640 IT Pros & Developers. It's quick & easy.

Queries - look up dates, sorting, etc.

P: 4
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
Mar 5 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.