basic counting problem

[Jean-Paul]

Hi,
I know this s basic but I don't know what I am doing wrong
My table with fields: datum (=translation for date) and therapist
I want to count the records per therapist with year(datum)=2006

Thanks people
An merry Xmas
JP

 

[Rick Brandt]

Hi,
I know this s basic but I don't know what I am doing wrong
My table with fields: datum (=translation for date) and therapist
I want to count the records per therapist with year(datum)=2006

Thanks people
An merry Xmas
JP

Open a new query, switch to SQL view, paste the following and then change
"TableName" to the name of your table.

SELECT therapist, Count(*) as RecordCount
FROM TableName
WHERE datum >=DateSerial(Year(Date()), 1, 1)
AND datum <DateSerial(Year(Date())+1, 1, 1)
GROUP BY therapist

 

[Jean-Paul]

perfect... it works, thanks
JP

Rick Brandt schreef: