Recent content by GordonCopestake

Hi Khawar, thanks for your swift reply. When I try your code I get the error: You tried to execure a query that does not include the specified expression 'Format([RaisedDate],"yyyy")' as part of an aggregate function.

Hi, I am trying to convert a table of data to a yearly/monthly summary and can't seem to work out how to do it. The data I have looks like this: ID | date | other info 1 | 01/01/11 | ... 2 | 04/01/11 | ... 3 | 06/01/11 | ... etc and I am trying to convert this to a simple count of...