Unanswered: How can I count the values of a datediff ?
I have a database which maintains all of the customer support calls for our customers. For reports I have a start and end date of a support issue. The amount of time to resolve the support issue is calculated in days using the DateDiff function, this works fine and returns the column in the report with all of correct figures. What I am trying to do now is to count the amount of returned records which will be:
The current results return a single digit where 0 is equal to less than 1 day, 1 = one day etc, no result means that the support problem is not resolved and still open.
I manaually count the amount of numbers at present but there are many pages and I am always looking for easier ways. Can this be achieved or do I have to use an array to store values, if so how?