formula

  • Thread starter Thread starter joe
  • Start date Start date
J

joe

Hi.

Trying to write a report that basically counts how many
tests a teachers corrects per day. My table has two
colums, teacher and tests. There are 5 teachers total.
What I need to do is add up the total tests done by each
teacher per day and display it on a form or report. Thanks
for any help!
 
If you are doing it "per day" it seems you are lacking a
Date column!

Something like this:

TRANSFORM Sum(MyTable.Tests) AS SumOfTests
SELECT MyTable.Teacher, Sum(MyTable.Tests) AS [Total Of
Tests]
FROM MyTable
GROUP BY MyTable.Teacher
PIVOT Format([Date],"Short Date");
 
Back
Top