Our team does numerous tests each month. Each person can run a report to automatically tally up all the results for the quarter. I have then created a Form specifically to enter our Analysis for the Quarter because it goes up to the CEO (so I seperated it because it has to have many revisions with our comments). For the Date Field I can't figure out the best way to put the date together for the Quarter.
Options I have come up with:
1. Create a drop down that have numbers 1-4 for each quarter than have a second field for the Year. Then in my Query could put them together.
2. I could just leave it as a Date field and let people enter dates in there and I could run a query to pull in all data between those dates.
3. Create another table altogther that has 1st Quarter 2008, 2nd Quarter 2008, etc and have a drop down box for each of the quarter than run the query that way.
Anyone have any other ideas or is one of these options above the best option I have?
Options I have come up with:
1. Create a drop down that have numbers 1-4 for each quarter than have a second field for the Year. Then in my Query could put them together.
2. I could just leave it as a Date field and let people enter dates in there and I could run a query to pull in all data between those dates.
3. Create another table altogther that has 1st Quarter 2008, 2nd Quarter 2008, etc and have a drop down box for each of the quarter than run the query that way.
Anyone have any other ideas or is one of these options above the best option I have?
Comment