access_asp thread: Finding the Avarage from the Database
Message #1 by Achimwene Dzida <dzidap@y...> on Mon, 15 Apr 2002 07:18:51 -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/
Message #2 by Abdul Sami <abdul_sami_20@y...> on Mon, 15 Apr 2002 11:21:02 -0700 (PDT)
|
|
The query could be:
select avg(milage) from tablename
--- Achimwene Dzida <dzidap@y...> wrote:
> 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/
>
=====
Abdul Sami
__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
Message #3 by "Richard" <dzidap@y...> on Tue, 16 Apr 2002 15:00:12
|
|
> The query could be:
select avg(milage) from tablename
--- Achimwene Dzida <dzidap@y...> wrote:
> 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/
>
=====
Abdul Sami
__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
|
View Cart
