I have a database which contains 230 records for the Month of September 2012.
Sept 1, I have 8 records
Sep 2, I have 18 records
Sept 3, I have 12 etc.
How do I get the count of days(unique count of day, in other words if Sept 1 have 8 records I want a field which should hold the value of 1 for Sep 1, and value 1 for Sep 2, value 1 for Sept 3 and so on... later I want to get a total of this value for some other calculations.
Any easy way other than writing complex script?