Number of days in a given month

Hi All,

I'm working on an uptime report for some devices. Each device checks in everyday. I'd like to show the percentage of check-ins per week and month per device.

Monthly report:
Device A checks in everyday of the month of July ( 31 checks ins), it'll shows 100% check in success.
Device B checks in only 10 times during the month of July is will show 32% check in success.

Would also like to have a weekly report:
Device C checks in once during the week it received a 14% success
Device D checks in five times during the week it receives a 71% success

Right now i've a table with everyday that the device checked in and that is related to another table with the device ID, friendly name, contact and other info.

Any help is much appreciated!!

-pete

------------------------------
Pete MacKenzie
------------------------------