If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
sum functions for several fields
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Populate Merge Fields via VB.NET | ben | Mailmerge | 5 | June 21st, 2005 05:43 PM |
improving performance by indexing query criteria fields | Paul James | General Discussion | 20 | February 16th, 2005 07:55 PM |
Can't Add Fields to Form | Jeff Miller | Using Forms | 4 | January 12th, 2005 03:42 AM |
Outlook contacts doesn't allow all fields from Excel? | gnmcewen | Contacts | 0 | January 9th, 2005 04:21 AM |
Automatic filling of fields in table two from table one | Jim Kelly | Database Design | 1 | September 27th, 2004 10:16 PM |