Results 1 to 5 of 5
  1. #1
    STarDavos is offline Novice
    Windows 10 Office 365
    Join Date
    Jan 2022
    Location
    Davos, Switzerland
    Posts
    11

    Date Filter in a Report


    How can I build a date filter into a report, using one field for start date and one field for end date, instead of right-click on the field column to filter?

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Use a form for the criteria, and open report using that criteria ?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    You should be opening the report with the date range filters. You're asking how to do this when the report is already open? I'm not a fan of putting buttons on a report, but if you must, you could do that and have it pop up a form where you enter the dates and click this form's button to alter the recordsource property or filter property of the report. To me, that's a hack and I would simply go back to whatever form you opened the report from and do it from there.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Perhaps have a textbox for start date and a textbox for end date on the form from which the report is opened and reference those textboxes as criteria in the reports underlying query. Another way would be to use a parameterized query for the report.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  5. #5
    STarDavos is offline Novice
    Windows 10 Office 365
    Join Date
    Jan 2022
    Location
    Davos, Switzerland
    Posts
    11
    Thanks for your help. I use a form now to open the report as you guys suggested. Thanks again!!! I will be back with more questions though...

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 12-30-2021, 02:29 PM
  2. print report with date filter
    By Jen0dorf in forum Access
    Replies: 3
    Last Post: 07-31-2015, 06:56 AM
  3. Filter Report by Optional Date Range and Combo Box
    By ARickert in forum SQL Server
    Replies: 3
    Last Post: 10-17-2012, 10:46 AM
  4. filter date from Query pass down to report
    By geraldk in forum Reports
    Replies: 1
    Last Post: 08-17-2012, 10:14 AM
  5. Code to combine report filter and date range
    By rhubarb in forum Reports
    Replies: 17
    Last Post: 10-28-2011, 03:08 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums