Calculating Weekly Totals

  • Thread starter Thread starter Van
  • Start date Start date
V

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
 
Perhaps something like this:

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