Pat Ferguson
Last Activity: Nov 26 '11, 11:28 AM
Joined: Nov 5 '11
Location:
-
ADezil, Option 2 would work best. Thank-yor for your help! I have been trying to get this for 2 weeks! Newbie -
Count the Number of Days per Month in a Date Range
Hi, I'm pretty new at Access queries and need a little help. I want to count the numbers of days in a date range by month. That is, date range is 5-Jan-05 to 3-Feb-05 (total DateDiff is 30), but how do I format a expr that would count/show that within the range, January has 27 days and February has 3 days of the total 30 days?
Thank in Advance, Newbie.
No activity results to display
Leave a comment: