Thread: Get date range from query
08-17-07, 05:56 #1Registered User
- Join Date
- Sep 2005
Unanswered: SOLVED: Get date range from query
I would like some guidance for the best way to do the following...
I have created a few reports to show percentages and figures for the data I am working with. To do this I created various queries showing the totals, which I then counted and summed to end up with the data needed to work out the percentages in the report. I have now been asked to include the date range from the first day we started recording this data to the latest date. I have tried to use the Min/Max method, but this has just brought back a date in the middle of the actual range, rather than the first and last date in the table.
UPDATE: Doesn't matter I just realised there is only one date in the table, so of course it will only return one date.
Last edited by KevCB226; 08-17-07 at 06:13. Reason: SOLVED:<- Hides behind a rock.
08-20-07, 21:31 #2Moderator
- Join Date
- Dec 2004
- Madison, WI
Does the "First"/"Last" work in a query for the date? Or can you have a table which has the first date you started recording the data (or hard-code this date into the report)?Expert Database Programming
MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)