Seperating Dates By Field.

Hello, this is my first post to these forums so... Hi.

I'm currently doing a select statement and I cannot figure out how to get it to do what I want it to.

I'm trying get the statement to show how much activity was done in each year in a separate field and I don't have any idea where to start to get this accomplished.

Here's the code:




select distinct client.Number as [ClientNumber], client.FirstName, client.LastName,
client.Address, client.City, client.State, client.Zip,
count(distinct [transaction].date) as VisitsWithinDateRange, client.LastVisit

from client

inner join [transaction] on client.number = [transaction].client

where

[transaction].date >= '01/01/1980'
and
[transaction].date <= '01/01/2008'
and
client.status like '%a%'
and
client.status not like '%n%'
and
client.status not like '%i%'
and
client.clienttype <> 'C'

group by client.number, client.Number, client.FirstName, client.LastName,
client.Address, client.City, client.State, client.Zip, client.LastVisit