Counting How many Sundays (or any day) in a given time range...

[Guest]

I have a table with 10,000+ records, each of which contains a field called
"DateOfCall" in short date format. If I run a query "Between [Date1] AND
[Date2]" how would I find out how many Sundays there were in that time
period??? Not how many times Sunday appears in the records being
queried(which I have managed to do on my own)!

Thanks
Marcus

 

[Dirk Goldgar]

I have a table with 10,000+ records, each of which contains a field
called "DateOfCall" in short date format. If I run a query "Between
[Date1] AND [Date2]" how would I find out how many Sundays there were
in that time period??? Not how many times Sunday appears in the
records being queried(which I have managed to do on my own)!

Funny you should ask.

http://www.mvps.org/access/datetime/date0011.htm
Date/Time: How many Sundays between two dates