Counting days within a month

[pickslides]

Hi guys, I have a start date and end date and looking to count the amount of days within each month, the following is an example of what I have

Customer, From Date, To Date, Days
1 10/02/2011 4/04/2011 53
2 11/02/2011 5/05/2011 83


and what I want my query to do separate each month and count the days within given the original To and From dates


Customer, Month, Days_in_Month
1 2 18
1 3 31
1 4 4
2 2 17
2 3 31
2 4 30

Anyone know some good cdoe?

 

[John Big Booty]

For a start have a look at the various Date manipulation function.

 

[John Big Booty]

Also check out the various grouping and counting options available in a Totals Query.