JeepsR4Mud
Registered User.
- Local time
- Today, 00:50
- Joined
- Sep 23, 2002
- Messages
- 70
Is there a way to calculate summaries for text fields?
I am designing a database for work. There are 33 sites. I have a table that records the new employee injuries by week and site.
I can do a count and determine the total number of injuries per site, but I'd like to know the average per week, and since the database in ongoing, the min and max/week.
I tried doing subtotals of each week, and calling that field weektotal. But, evidently the avg, min, and max fields won't work with unbound fields. I also tried copying the count command: AVG(COUNT([weektotal])) but you cant do two functions (AVG and COUNT in the same field.
Thanks.
Gayle Ann
I am designing a database for work. There are 33 sites. I have a table that records the new employee injuries by week and site.
I can do a count and determine the total number of injuries per site, but I'd like to know the average per week, and since the database in ongoing, the min and max/week.
I tried doing subtotals of each week, and calling that field weektotal. But, evidently the avg, min, and max fields won't work with unbound fields. I also tried copying the count command: AVG(COUNT([weektotal])) but you cant do two functions (AVG and COUNT in the same field.
Thanks.
Gayle Ann