Calculate # of Hiolidays within a Date Range

  • Thread starter Thread starter aMack
  • Start date Start date
A

aMack

I need to generate a query result that gives me the count of holidays within
a date range:

Holiday Table contains 12/24/08, 12/25/08 and 1/1/09.

A sample date Range is from 12/1/2008 to 1/5/2009 - I need the result to be 3.

Can this be done in a simple query?
 
DCount("*", "Holidays","[HolidayDate] Between #12/1/2008# And #1/5/2009#")
 
Back
Top