Results 1 to 2 of 2
  1. #1
    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 05:13. Reason: SOLVED:
    <- Hides behind a rock.

  2. #2
    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)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts