calculation with msaccess

[Joost]

Hi,

I have a msaccess database with more then 50 tables. Each table exist of the
history off a specific truck data and excist of a honderd records in each
table.
(deparute date, arrival date, destination etc.). I want to calculate from
the last 5 records in each table the averge between the arrival and
desination dates.
How can this be done

Thanks anyway

[Br]

Joost <no****@home.nl> wrote:

Hi,

I have a msaccess database with more then 50 tables.
Why seperate tables when you are storing the same info?
Each table exist
of the history off a specific truck data and excist of a honderd
records in each table.
(deparute date, arrival date, destination etc.). I want to calculate
from the last 5 records in each table the averge between the arrival
and desination dates.
How can this be done

Thanks anyway

Something like...

SELECT Avg([Difference]) AS AvgDays
FROM
(SELECT TOP 5 DateDiff("d",[Departure],[Arrival]) AS Difference FROM
tblTruck);

--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response