sum functions for several fields

I have a database that consists of a list of Activities. For each actitivy I
have 31 columns each representing a day of the month. In these fields I will
enter a score of 1, 2 or 3 which represents the level of activity for that
day. I need to create a report that tallies the count of days active,
average score and total score for each activity. I need to be able to sort by
Activity, as well as for each Person and by date. How do I add and average
the 31 days of the month and have a total by Activity?
My Fields are : Activity/ 1, 2, 3, 4, 5, etc./ Person

Is there any way that you can normalize your table? Each score for each day
for each person should create a new record. If your table was structured
properly, the SQL to create averages, counts,... would be simple.

--
Duane Hookom
MS Access MVP
--

"Kate984u" wrote in message
...
I have a database that consists of a list of Activities. For each actitivy
I
have 31 columns each representing a day of the month. In these fields I
will
enter a score of 1, 2 or 3 which represents the level of activity for that
day. I need to create a report that tallies the count of days active,
average score and total score for each activity. I need to be able to sort
by
Activity, as well as for each Person and by date. How do I add and
average
the 31 days of the month and have a total by Activity?
My Fields are : Activity/ 1, 2, 3, 4, 5, etc./ Person