Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Sep 2007
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Find Between Dates (2000)

    I'm looking for a query that can take 2 dates the user enters and filters the table date field to all records that are between those 2 dates.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Find Between Dates (2000)

    Create a query based on the table.
    Add the relevant date field and the other fields that you want to display in the query.
    Enter the following expression in the Criteria line for the date field:

    Between [Enter Start Date] And [Enter End Date]

    When you switch to datasheet view, you'll be prompted to enter the start and end dates.

Posting Permissions

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