Calculate Average Cases per month

[ashab02]

Hello

I have a set of data for a year (2006) and I have a specific column which is a date field. This date field is the date the case was passed to us.

I would like now to create an average using this date field to give me a figure for 'Average number of cases per month'.

I was wondering how I would use this. I have built my quries using views and GUI of SQL Server.

I was thinking getting a count of the cases and then dividing by twelve. Not sure if this will work.

Can someone help please?

Shab

 

[AlexCuse]

count / 12 should work. Try it out and let us know. If it doesn't work, please post the query to make things a little easier.

Hope this helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[ashab02]

Hello

Thats what I thought.

Thanks for the reply

If anyone else has any other ideas then please let me know

Shab

 

[AlexCuse]

So, did it not work?

Ignorance of certain subjects is a great part of wisdom

 

[ashab02]

sorry i wont be able to test till tommorrow

I'll let you know tommorrow morning.

thanks for help so far