Hi,

I need to analyse some data that is held in an Access database, but I want
to do this in Excel.

I have the data in an Access Query.

My data is about 7500 records and increasing by 200 records per month.

The data record consists of three fields

Date in mmm-yy format

Text String1

Text String2



I want to group my data in Excel by month with the latest month at the top.
I then want to have a count of TextString1 and a count of TextString2. As
an example:



Month Text String1
Text String 2

Sept-07 25
36

Aug -07 62
89



I am lost as to the best way of doing this, and would appreciate some advise
please



Thanks

A