Totalling records

[Arthur via AccessMonster.com]

I have a table in a MS Access database that records health & safety incidents
relevant to calendar month, by categories of minor injury and lost-time
injury etc. To help speed-up the process of accessing data relevant to these
incidents I thought I'd try to create a table that will contain values of the
totals number of incidents of the incident categories within each calender
month.

For example the new table would contain the total number of minor injuries
relevant to January, and the total number of minor injuries in February etc.
for all months in the year and for all incident categories in the first table.


Additionally, if an additional incident is added to the first table I would
like the totals table to be automatically updated to reflect the new
additional record. What would be the best way of doing this, and how do I do
it.

 

[Jeff Boyce]

Arthur

There's rarely a need to create a new table holding summarized data from
another table.

Instead, consider using Totals queries, or, if you want to see totals per
month, look into Crosstab queries and Crosstab reports.

Regards

Jeff Boyce
Microsoft Office/Access MVP