basic counting problem

  • Thread starter Thread starter Jean-Paul
  • Start date Start date
J

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
 
Jean-Paul said:
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
Click to expand...


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
 
Back
Top