Calculating hourly average from large data set

N

~~NRH~~

I have a large set of traffic data (55000+ rows and 15 columns). Each row
contains the data of one vehicle passing through a survey location.

The columns include the time at which the vehicle passed the survey
location, it's velocity, a property called headway etc...

I would like to work out the average velocity and headway of the vehicles
passing through the survey location for each hour (remembering that the
number of vehicles and hence rows is different for every hour).

Any ideas?
 
D

Daryl S

NRH -

You can use the database functions to calculate the counts and averages,
using the time fields for your criteria. Look at the help in Access for
DCOUNT, DAVERAGE, and Database in general.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hourly Averages 3
Average if questions 2
VLOOKUP with a date, from A1 = Now() 3
skipping rows for running average calculation 0
Creating a Chart on form from selected data in query. 0
form validation determines which sheet to add data 1
Averaging Hourly Data 2
How do I average hourly data into daily data? 1

Top