Re: Total short time fields in query

I normally don't do it this way either.  In the end they want re****ts
that will show totals and that is what I'm working on.  I'm trying to
figure out the best way to deal with this issue.

Any other ideas?

On May 4, 6:01=A0pm, "KC-Mass" <connearneyATcomcastDOTnet> wrote:
> I think generally that you do not want to total times. =A0What would the
t=
otal
> of 18:00 and 14:30 and 4:00 mean or be useful for? =A0Perhaps the result
o=
f
> subtracting one time from another, yielding elapsed times can be added
> usefully?
>
> Regards
>
> Kevin
>
> "Ecohouse" <ecovinda...@[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. =A0It is in
Access
> > 2003. =A0There are short time fields which get calculated values (eg.
> > 1:30). =A0But I will need to total up those values for re****ts in
> > qiueries. =A0When 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? =A0Thanks in
> > advance for the help.- Hide quoted text -
>
> - Show quoted text -