Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2013
    Posts
    1

    Unanswered: Creating a report for selected date

    In my DB I have a table and a form called CMS. Within that table is a field called "VISIT DATE" which is a date/time field.

    I have a report ("Todays Externals") which comes from a query (also called "Todays Externals") that amongst other fields contains that date field.

    The query has "Date()" in the date box so I can get a list of all records with todays date in.

    What I want to do is have a text box on the switchboard where I can enter any date, then click a search button to bring up the report showing records for that date, but I have no idea where to begin with this.

    Could someone please help?

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Instead of Date() in the criteria, you'd have

    Forms!FormName.TextboxName

    Another option is taking the criteria out of the query and using this technique:

    http://www.baldyweb.com/wherecondition.htm
    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
  •