Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access_asp thread: Finding the Average from the Database


Message #1 by Achimwene Dzida <dzidap@y...> on Fri, 19 Apr 2002 08:29:20 -0700 (PDT)
I thank you for the help you render as a i am new in
this language.
I appreciate .

i have the following table 

TRVEL_DATE       STATUS      MILAGE(KM)
1/1/02 10:50:21    Start    12300
1/1/02 12:00:30    stop     12360
1/1/02 12:30:45    start    12360
1/1/02 13:01:68    stop     12480
4/1/02 12:00:88    start    12486
4/1/02 12:30:34    stop     12500
4/1/02 16:30:80    start    25700

These recordings can go on up to the end of the month.
From these figures what code can be used to find the
average kilometer per hour for a month. i have made
the connection alright, but the core of the code bangs
my head.

Thanx in advance for your help





__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/

  Return to Index