Calculate # of Hiolidays within a Date Range

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?
 
D

Douglas J. Steele

DCount("*", "Holidays","[HolidayDate] Between #12/1/2008# And #1/5/2009#")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crosstab Query based on Ordinal Values 6
Calculate sum of a field within the query 1
Delete Duplicates 2
Start Date/ End Date query 7
Odd results from Crosstab w/ Date/Time field 1
run sum 1
Append Query - return data for each day within a date range 2
Selecting first record from a sorted query 6

Top