Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    May 2003
    Location
    Austin, Texas, USA
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date Range in Report (2002 SP3)

    I know this should be easy, but I haven't used Access in about a year and a half, and I just can't seem to remember how to do it. Each record in the query that my report is based on includes a date field. I want to include the range of all the dates in my query in the report header, e.g. "from 11/26/04 to 2/17/05".
    Can anyone help me?
    Thanks in advance.
    Celest

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Date Range in Report (2002 SP3)

    If it's a parameter query with parameters - for example - [Start Date] and [End Date], you can use a text box with control source

    ="From " & [Start Date] & " to " & [End Date]

    If not, you can use

    ="From " & Min([DateField]) & " to " & Max([DateField])

    where DateField is the name of the date field. If you want special formatting, you can wrap the dates in a Format expression, e.g.

    ="From " & Format(Min([DateField]),"dddd mmmm d, yyyy") & " to " & Format(Max([DateField]),"dddd mmmm d, yyyy")

  3. #3
    New Lounger
    Join Date
    May 2003
    Location
    Austin, Texas, USA
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Range in Report (2002 SP3)

    Yep, that did the trick for me. Thanks so much for your help.
    Celest

Posting Permissions

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