Is there a way to show the dates between Two dates excluding weekends and
holidays?
I have a function that gives me the number of days. But would like to see
the days as dates.
Floyd
You'll need a calendar table containing one record for each workday.
You can fill this pretty easily using Excel fill-down, and import it
into Access; to delete all Saturdays and Sundays, you can use a Delete
query
DELETE * FROM tblCalendar
WHERE DatePart("w", [datefield]) IN (1, 7);
For holidays... you'll either need to delete them by hand, or create a
table of holidays observed by your business and delete them.
You can then do a simple query on this table to get the dates.
John W. Vinson[MVP]
