"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.
I'm confused, when you say "there are short time fields" do you mean a
field
containing values like 3:30pm, 4:00pm, 12:14am, etc? Or do you mean a
field
containing values of elapsed time like 1.20 secs, 5.50 hrs, etc. The
former
is formatted as date/time, the latter is a number. A summation of the
former
doesn't make sense, but the summation of the latter does.
Fred Zuckerman
|
