Results 1 to 2 of 2
  1. #1
    hbernard is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Sep 2016
    Posts
    1

    Exclamation Selecting nonconsecutvie dates


    I've created a query that accepts a start and end date as parameters in Access 2013. If today's date is within that range, a formula is triggered that outputs "no bus" on another page. And that's great! But here is my problem. I would like to have the option to select a range of numerous non consecutive dates (for example, every Monday, Wednesday and Friday between September 26th - October 28th). Any help/suggestions would be graciously received.

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    Maybe the Weekday() function would be helpful to you.
    https://msdn.microsoft.com/en-us/lib.../gg264334.aspx

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

Similar Threads

  1. Selecting dates...
    By lithium in forum Programming
    Replies: 7
    Last Post: 06-27-2016, 06:12 PM
  2. Replies: 8
    Last Post: 12-02-2013, 03:46 PM
  3. Query input dates for range of dates in two fields
    By kagoodwin13 in forum Queries
    Replies: 3
    Last Post: 02-13-2012, 04:25 PM
  4. Selecting Dates
    By jpalk in forum Queries
    Replies: 3
    Last Post: 05-21-2010, 06:08 AM
  5. Selecting between two dates
    By nicorvp in forum Queries
    Replies: 5
    Last Post: 05-04-2010, 08:17 AM

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