Help with query

[orna]

Hi
I have 2 fields in a table: StartDate, EndDate
and need to make a chart:
count records where the diff between the dates:
0-10 days
11-20 days
.
.
>365 days

How can i build the crosstab query?
TIA

 

[PHV]

A Starting point:
SELECT Int((EndDate-StartDate)/10) As Decade, Count(*)
FROM YourTable
WHERE EndDate<=StartDate+369
GROUP BY Int((EndDate-StartDate)/10)
UNION SELECT 99, Count(*)
FROM YourTable
WHERE EndDate>StartDate+369

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[orna]

Thanks PH

I didnt quite understand what did you mean but you gave
me the right direction and i manage to get it work.