Results 1 to 3 of 3
  1. #1
    knightjp is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2008
    Posts
    11

    Searching Dates

    Hey guys,

    I new to access. I would like to specify two dates and have my database display all the strings within those two dates.
    Any ideas on how this can be done???

  2. #2
    Join Date
    Aug 2008
    Posts
    8
    In a query set the criteria for the date field to be:

    Between #[What is first date?]# and #[What is last date?]#

    When you run the query you will be prompted for the first date and the last date...your results will be all the data between these dates.

  3. #3
    knightjp is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2008
    Posts
    11
    Thanks "jfgambit"

    Your suggestion worked like a charm. Now I just have to find a way of turning the results into a report.

    Thanks everyone for the help.

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

Similar Threads

  1. Searching for a single word in all table
    By rielcas in forum Access
    Replies: 1
    Last Post: 06-19-2013, 06:28 AM
  2. calculating due dates in access
    By trixxnixon in forum Forms
    Replies: 0
    Last Post: 09-28-2008, 12:35 PM
  3. Help with Searching Dates
    By rededdie in forum Access
    Replies: 1
    Last Post: 11-02-2007, 08:34 AM
  4. Having trouble with dates in my Data Base!!!!
    By BigPhil in forum Queries
    Replies: 4
    Last Post: 02-15-2006, 12:47 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