so ive set up performance monitor alerts on all our servers and now id like to set up counters to do some informational and trend analysis. So you can save counter logs right to .csv files or to an sql database, unfortunately in my case access. Its just a big flat database, first field is the time then all the rest are the records taken for different counters. I would like to try and write a query that evaluates the time by the hour and then comes up with 1 average for each counter for that hour. All i can get in access is it to list all the recordings from a particular hour but i have no idea how to get it to give me just the avg of those records. please help!