Results 1 to 3 of 3
  1. #1
    0000 is offline Novice
    Windows Vista Access 2002
    Join Date
    May 2011
    Posts
    2

    Wink Query Criterea

    Im creating a driving instructor database to find store information about lesson bookings. All the dates are stored in a table. I have created queries for each instructor and i now need them to find the lesson times for the next day and the next 3 days.


    I have used date()+1 for the next day, what do i use to find the next 3

    Its probably really simple. thanks

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    In your criteria use:
    Code:
    Between Date()+1 and Date()+3

  3. #3
    0000 is offline Novice
    Windows Vista Access 2002
    Join Date
    May 2011
    Posts
    2
    Thanks a lot

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

Similar Threads

  1. Replies: 8
    Last Post: 02-19-2011, 05:48 PM
  2. split form select records based on a criterea
    By ramkitty in forum Access
    Replies: 8
    Last Post: 03-12-2010, 06:19 PM

Tags for this Thread

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