Go Back   Access World Forums > Microsoft Access Discussion > Queries

Thread Tools Rate Thread Display Modes
Old 12-09-2009, 01:23 AM   #1
Registered User
Join Date: Dec 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
billwest is on a distinguished road
Show dates between a date range

I am building a simple holiday planner for drivers who are available or not available on a daily basis. The database consists of a table with drivers names and ID and a table with holidays or days off. The method of booking holidays is based on name, begin date, end date and approval.
What i want to do is be able to open a list of all drivers available to work so that i can fill in a plan board. The list should show all the drivers and on the days that the driver is not availble a code "off" or "NA". The biggest problem is that the date range has to show weekends as i want to plan 7 days a week. Unitll now i have only found scripts that work with weekdays and not incl. weekends.
Can anyone help me with this please?

billwest is offline   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Date Range Problem gargara Queries 5 02-25-2009 07:22 AM
Show datediff summary as 0 is dates are null or < date() jk12 Queries 1 12-09-2008 03:50 AM
Date range From Within Report klynch0803 Reports 2 02-20-2008 09:45 AM
Case Select - Report OnOpen - Date Range ? misscrf Reports 19 10-29-2005 01:03 PM
Multiple queries using one date range legendv Queries 3 10-17-2002 06:10 PM

All times are GMT -8. The time now is 12:21 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World