sum functions for several fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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