Calculating Weekly Totals

[Van]

I have a data base in Access XP that tracks total number of visits each
Friday for 6 or 7 years.

I want to count the number of visits for each year. My query has the
following fields:

Year Date (Friday) Department Site Visits

Any suggestions?

Thanks in advance
Van Reed

 

[Ken Snell]

Perhaps something like this:

SELECT Year, Department, Sum(Visits)
FROM TableName
GROUP BY Year, Department;