Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004

    Unanswered: Microsoft Access

    I have a query that I am using a parameter value, but in the report by default it prints the first date found in query when I call that field.

    Between [Type the beginning date 00/00/0000:] And [Type the ending date 00/00/0000:]

    so I created the following line in my report to print the first date and the last date and it works for the first date but not the last date in the report:

    ="Repair History" & " " & Format$([DateClosed],"mmmm yyyy",0,0) & " " & "Through" & " " & Max(Format$([DateClosed],"mmmm yyyy",0,0))

    but this only gives the largest date on the first page.

    Please help!!!

  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    That seems a bit odd.. So you end up with LARGER values in subsequent pages then what's displayed in Max(dateclosed)?

  3. #3
    Join Date
    Apr 2004

    Microsoft Access

    The max value displayed is the largest date on the first page which is 2003 but I have date in 2004. Therefore it should show month 2004.

Posting Permissions

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