Ecohouse <ec*********@yahoo.comwrote in
news:3d824645-d110-47a3-958d-170c4afa394a@
24g2000hsh.googlegroups.com
:
A field would have the value of 1:30. This would represent one
hour and thirty minutes. I didn't set this up and now I'm stuck
with it and trying to figure out a way to deal with this.
So I have to create reports where I will be grouping departments
and I need the total hours and minutes. I'm trying to do this
using the query builder. Any ideas?
So you are talking of durations and not times. Access stores the
date and time as the number of dats since Dec 31, 1899 and the
fraction of the day reresents the time. e.g. noon is 0,5, 6:00 pm is
0.75.
So first you need to determine if there is a hidden date in the
field, then subtract that from the shown value, and total the
fractions, then redisplay as as a duration.
If instead the time is stored in a text field, not date-time, you
will need to write a function in Visual basic code to split the
parts into a fraction of a day, then sum and reformat as a duration.
until anyone can give you specific instructions, we'll need to know
1) the field type (open the table in design mode),
2) the field format,
3) if a datetime field, whether the dates are all 12-31-1899 or
various recent dates, build a query and format the field as general
date.
Q
On May 5, 4:25*am, "Fred Zuckerman" <Zuckerm...@sbcglobal.net>
wrote:
>"Ecohouse" <ecovinda...@yahoo.comwrote in message
news:3476a795-6e48-4aad-8f80-
c3**********@k37g2000hsf.googlegroups
>.com...
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 reports 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 fie
ld
>containing values like 3:30pm, 4:00pm, 12:14am, etc? Or do you
mean a fiel
d
>containing values of elapsed time like 1.20 secs, 5.50 hrs, etc.
The forme
r
>is formatted as date/time, the latter is a number. A summation of
the form
er
>doesn't make sense, but the summation of the latter does.
Fred Zuckerman
--
Bob Quintal
PA is y I've altered my email address.
** Posted from
http://www.teranews.com **