Results 1 to 3 of 3
  1. #1
    Marie is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2011
    Posts
    2

    Scheduling Problem

    Hello, I have a database where I schedule drivers' routes. I use a form to enter the route date, route number (drop down box), and the driver's name (drop down box). If the driver is not available for the particular route currently being scheduled due to a day off or vacation day, I want to have the drop down box not include that particular driver's name. The tables are Drivers, Routes, Driver/Route Link, (many to many), and Time Off table. If I put the driver name and day off in the day off table, how can I accomplish not having his/her name not populated with the available drivers? Thanks.

  2. #2
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    use left join.
    for example, get all name of drivers but excluding the names in dayOffTable.
    select name from driverTable as a left join dayOffTable as b on a.driverID=b.driverID where b.driverID is null

  3. #3
    Marie is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2011
    Posts
    2
    Thank you for your reply. I will try this and let you know how it works out.

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

Similar Threads

  1. scheduling db
    By JSHEL in forum Database Design
    Replies: 1
    Last Post: 12-12-2010, 09:28 AM
  2. Replies: 2
    Last Post: 06-14-2010, 03:25 PM
  3. Scheduling database in Access
    By ACS Newbie in forum Access
    Replies: 4
    Last Post: 01-21-2010, 10:32 PM
  4. query problem i have a problem wi
    By maxx3 in forum Queries
    Replies: 0
    Last Post: 06-29-2009, 02:29 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