Re: Total short time fields in query

I think the basic problem is that your predecessor used the wrong data
type.
The data should have been stored as a number.

Try converting it to a number in a query. Put an Expression in the query 
that
multiplies the timefield by 1440 (giving minutes) and divide that by 60 
(giving hours).

A "Time" of 3:30  will give you 3.50.  You can the sum those values.

The SQL would be something like:
"SELECT Sum([timeforprocess]*1440/60) AS NumbersFROM tblTime; "

I am guessing this is what you need.

Regards
Kevin




"Ecohouse" <ecovindaloo@[EMAIL PROTECTED]
> wrote in message 
news:3476a795-6e48-4aad-8f80-c34a494b6d3b@[EMAIL PROTECTED]
> I'm working on a project that was dropped in my lap.  It is in Access
> 2003.  There are short time fields which get calculated values (eg.
> 1:30).  But I will need to total up those values for re****ts in
> qiueries.  When I tried to drop one of the fields in the query builder
> and used the total function the totals was way off.
>
> So I was wondering what would be the best way to do this?  Thanks in
> advance for the help.