Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2004
    Location
    UK
    Posts
    4

    Unanswered: Filter out a start date and end date

    I need to be able to prompt a user for a start date and also an end date.

    Once they enter the correct information i need to be able to filter and only display all the relevant records between the start date and the end date.

    The Date format im using is short date if that helps.

    please help as im really stumped on this.

    many thanks

  2. #2
    Join Date
    Aug 2002
    Location
    Northampton, England
    Posts
    266
    Add the criteria between [Enter start date] And [Enter end date] in the criteria of the date field in the query.

  3. #3
    Join Date
    Nov 2004
    Location
    Kansas City, KS
    Posts
    4
    >=[Start Date] and <= [End Date]

    Digger

  4. #4
    Join Date
    Aug 2004
    Posts
    13
    between [start date] and [end date], this will prompt you for the dates. You can also use text controls on a form to complete the dates in. Then put the [forms]![form name]![control name]. You can use format(criteria, short date) or format(field Name, short date) to change the formats to match. Hope this helps

  5. #5
    Join Date
    Sep 2004
    Location
    Charlotte, NC
    Posts
    164
    DJN got it right. If you place 'Between [Enter start date] And [Enter end date]' in the criteria of the date field in the query, when you run the query, you should have a parameter request box pop up that says "Enter start date" and then another one that says "Enter end date". When I do this, I usually name my dynamic criteria field something like [Enter Start Date (MM/DD/YY)] so that the user knows how I expect to have the date entered.

    TD

  6. #6
    Join Date
    Sep 2004
    Location
    UK
    Posts
    4
    thanks for the help guys.

    Between [Start date] AND [End date] worked great

    thanks again

Posting Permissions

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