Results 1 to 4 of 4

Thread: Date filter

  1. #1
    Join Date
    Sep 2011
    Posts
    33

    Unanswered: Date filter

    Hello,

    I'm new to access and was wondering if someone could help me.

    I would like to be able to input a specific date into an unbound textbox and then open a report with all data related to just the date I have entered. I've managed to work out how to create a command button to open the report but I don't know where to start with the date filter.

    Do I need to write code for this? Or can I set criteria to the textbox?

    I know I can set the criteria in the query as the date, but as the date changes often I don't want to have to keep going into the query to change it.

    I hope that makes sense.

    Thanks in advance.

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

  3. #3
    Join Date
    Sep 2011
    Posts
    33
    Thanks heaps pbaldy. works great.

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Happy to help!
    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
  •