I am trying to extract data from 2 tables, one that I use track Downtime for mutliple plants, each plant has 6 possible events that can be assigned a code from 1 to 11, and an associated time value. The Codes table has an ID field and a Descrition Field. I would like to count the codes that were used during a month and the associated time assigned to each code. I am not sure how to go about this in access?
Help!
