In my Access database I have 800 records which have 140 or so dates.
In totally there are around 102,000 dates. I would like to know how to group by month as a field then cumulative count them to produce a s-curve graph.
i.e. jan-00 5 Feb-00 7 and so on....
The data must be exportable into Crystal Reports.
I can produce a CrossTab Query which creates/Formats a column yyyy-mm and counts the amount in that range but, doesn't count cummulative. Can this be done.
Any help appreciated.