Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2012
    Posts
    68

    Unanswered: print report for only certain dates in a field

    so here is my code

    Code:
    Private Sub Command41_Click()
    
        DoCmd.OpenReport "test", acViewPreview, , reportdate = [Ending Week Date]
    When the report pops-up it hows all of the records from my table and not just the date entered into the "reportdate"txtbox.

    Any ideas?

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    See here for the correct syntax for a date field:

    Open a second form to the record
    Paul

  3. #3
    Join Date
    Mar 2012
    Posts
    68
    Thanks again Baldy! Working great

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    No problemo!
    Paul

Posting Permissions

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