sum of "Short Time" Column

Hi guys,

I've done an extensive search for this, and found similar problems, but
nothing spesific to Short Time that helped me.
I have a database- one table consists of two columns : Associate ID and Time
.. There is no primary key.
I generated a report, The Associate ID being the one and only grouping
level. So the report will show me teh Associate ID, and underneath it it will
list all the recorded times for the assocaite it will look something like
this :

***************************
Assocaite ID abc0101
Time
01:00
00:05
00:30
Associate ID sam0556
Time
00:06
00:10
00:30

********************************
....and so on
What I want to do is to be able to add in my report the Total time (SUM) of
all the individaul times per associate. I was unsuccessful with many time
putting =Sum([Time]) in the page header and other places. Most of the time I
get #error
Please Help!! However , I am an NEWBIe, so please try to give me the easiest
solution.Thank you

It looks like I have labeled the Time Field in my table as "text" rather than
"Number". Now if I am to change it to Number.. it will screw up my database
of like 200 entries. Is there a way to fix this without screwing up my data?
Thank you


"bigo" wrote:

Hi guys,

I've done an extensive search for this, and found similar problems, but
nothing spesific to Short Time that helped me.
I have a database- one table consists of two columns : Associate ID and Time
. There is no primary key.
I generated a report, The Associate ID being the one and only grouping
level. So the report will show me teh Associate ID, and underneath it it will
list all the recorded times for the assocaite it will look something like
this :

***************************
Assocaite ID abc0101
Time
01:00
00:05
00:30
Associate ID sam0556
Time
00:06
00:10
00:30

********************************
...and so on
What I want to do is to be able to add in my report the Total time (SUM) of
all the individaul times per associate. I was unsuccessful with many time
putting =Sum([Time]) in the page header and other places. Most of the time I
get #error
Please Help!! However , I am an NEWBIe, so please try to give me the easiest
solution.Thank you

Dear Bigo:

To save yourself from losing anything, create a new column for Time with the
desired datatype. Update that with the existing time values and make sure
it comes through properly. Keep the old one around until you're sure you
don't need it anymore.

I'm not getting into what else you have here, at least not yet. I just
wanted to get this suggestion to you promptly.

Tom Ellison


"bigo" wrote in message
...
It looks like I have labeled the Time Field in my table as "text" rather
than
"Number". Now if I am to change it to Number.. it will screw up my
database
of like 200 entries. Is there a way to fix this without screwing up my
data?
Thank you


"bigo" wrote:

Hi guys,

I've done an extensive search for this, and found similar problems, but
nothing spesific to Short Time that helped me.
I have a database- one table consists of two columns : Associate ID and
Time
. There is no primary key.
I generated a report, The Associate ID being the one and only grouping
level. So the report will show me teh Associate ID, and underneath it it
will
list all the recorded times for the assocaite it will look something like
this :

***************************
Assocaite ID abc0101
Time
01:00
00:05
00:30
Associate ID sam0556
Time
00:06
00:10
00:30

********************************
...and so on
What I want to do is to be able to add in my report the Total time (SUM)
of
all the individaul times per associate. I was unsuccessful with many time
putting =Sum([Time]) in the page header and other places. Most of the
time I
get #error
Please Help!! However , I am an NEWBIe, so please try to give me the
easiest
solution.Thank you

Tom,
It sounds like a great suggestion, and I sincerely appreciate your prompt
response.
I will attempt that.

"Tom Ellison" wrote:

Dear Bigo:

To save yourself from losing anything, create a new column for Time with the
desired datatype. Update that with the existing time values and make sure
it comes through properly. Keep the old one around until you're sure you
don't need it anymore.

I'm not getting into what else you have here, at least not yet. I just
wanted to get this suggestion to you promptly.

Tom Ellison


"bigo" wrote in message
...
It looks like I have labeled the Time Field in my table as "text" rather
than
"Number". Now if I am to change it to Number.. it will screw up my
database
of like 200 entries. Is there a way to fix this without screwing up my
data?
Thank you


"bigo" wrote:

Hi guys,

I've done an extensive search for this, and found similar problems, but
nothing spesific to Short Time that helped me.
I have a database- one table consists of two columns : Associate ID and
Time
. There is no primary key.
I generated a report, The Associate ID being the one and only grouping
level. So the report will show me teh Associate ID, and underneath it it
will
list all the recorded times for the assocaite it will look something like
this :

***************************
Assocaite ID abc0101
Time
01:00
00:05
00:30
Associate ID sam0556
Time
00:06
00:10
00:30

********************************
...and so on
What I want to do is to be able to add in my report the Total time (SUM)
of
all the individaul times per associate. I was unsuccessful with many time
putting =Sum([Time]) in the page header and other places. Most of the
time I
get #error
Please Help!! However , I am an NEWBIe, so please try to give me the
easiest
solution.Thank you

Tom,
I ran into a problem. Do you mean copy the data from the existing
"Text-type" column to the new "number-type" colum i've just created? Because
if that is the case, I tried to do that and i got an error, "the value you
entered isnt valid for this field"
Thank you

"Tom Ellison" wrote:

Dear Bigo:

To save yourself from losing anything, create a new column for Time with the
desired datatype. Update that with the existing time values and make sure
it comes through properly. Keep the old one around until you're sure you
don't need it anymore.

I'm not getting into what else you have here, at least not yet. I just
wanted to get this suggestion to you promptly.

Tom Ellison


"bigo" wrote in message
...
It looks like I have labeled the Time Field in my table as "text" rather
than
"Number". Now if I am to change it to Number.. it will screw up my
database
of like 200 entries. Is there a way to fix this without screwing up my
data?
Thank you


"bigo" wrote:

Hi guys,

I've done an extensive search for this, and found similar problems, but
nothing spesific to Short Time that helped me.
I have a database- one table consists of two columns : Associate ID and
Time
. There is no primary key.
I generated a report, The Associate ID being the one and only grouping
level. So the report will show me teh Associate ID, and underneath it it
will
list all the recorded times for the assocaite it will look something like
this :

***************************
Assocaite ID abc0101
Time
01:00
00:05
00:30
Associate ID sam0556
Time
00:06
00:10
00:30

********************************
...and so on
What I want to do is to be able to add in my report the Total time (SUM)
of
all the individaul times per associate. I was unsuccessful with many time
putting =Sum([Time]) in the page header and other places. Most of the
time I
get #error
Please Help!! However , I am an NEWBIe, so please try to give me the
easiest
solution.Thank you

Dear Bigo:

OK. The column from which you are copying is text, and contains a colon.
Right?

The column to which you're copying this is what?

If it is datetime, then convert the text data to datetime using CDate().
Don't past it in. Write an update query to do it.

Any better? If not, give details of what is being done, and what is wrong.

Tom Ellison


"bigo" wrote in message
...
Tom,
I ran into a problem. Do you mean copy the data from the existing
"Text-type" column to the new "number-type" colum i've just created?
Because
if that is the case, I tried to do that and i got an error, "the value you
entered isnt valid for this field"
Thank you

"Tom Ellison" wrote:

Dear Bigo:

To save yourself from losing anything, create a new column for Time
with the
desired datatype. Update that with the existing time values and make
sure
it comes through properly. Keep the old one around until you're sure
you
don't need it anymore.

I'm not getting into what else you have here, at least not yet. I just
wanted to get this suggestion to you promptly.

Tom Ellison


"bigo" wrote in message
...
It looks like I have labeled the Time Field in my table as "text"
rather
than
"Number". Now if I am to change it to Number.. it will screw up my
database
of like 200 entries. Is there a way to fix this without screwing up
my
data?
Thank you


"bigo" wrote:

Hi guys,

I've done an extensive search for this, and found similar problems,
but
nothing spesific to Short Time that helped me.
I have a database- one table consists of two columns : Associate ID
and
Time
. There is no primary key.
I generated a report, The Associate ID being the one and only
grouping
level. So the report will show me teh Associate ID, and underneath
it it
will
list all the recorded times for the assocaite it will look something
like
this :

***************************
Assocaite ID abc0101
Time
01:00
00:05
00:30
Associate ID sam0556
Time
00:06
00:10
00:30

********************************
...and so on
What I want to do is to be able to add in my report the Total time
(SUM)
of
all the individaul times per associate. I was unsuccessful with many
time
putting =Sum([Time]) in the page header and other places. Most of
the
time I
get #error
Please Help!! However , I am an NEWBIe, so please try to give me the
easiest
solution.Thank you

Ok. Here is my problem. I have a database of time for associates. By time,
what I really mean is the number of minutes the associate has worked. For
example if associate abc worked 5 minutes, i entered it in "short time" as
00:05. If associate xyz worked for 1 hour, it was inputed as 01:00. Now from
reading other threads, it appears I should not have used Short Time. To add
to this big mess, the column, that has all the times ( in short time format)
is set up as "text" data type.

So, What I aim to achieve is to convert this column data type from text to
number. However, I guess I must first some how convert the format -being
"Short time" to hours and minutes.
Hope this clears it up a little.
Thank you again.

"Tom Ellison" wrote:

Dear Bigo:

OK. The column from which you are copying is text, and contains a colon.
Right?

The column to which you're copying this is what?

If it is datetime, then convert the text data to datetime using CDate().
Don't past it in. Write an update query to do it.

Any better? If not, give details of what is being done, and what is wrong.

Tom Ellison


"bigo" wrote in message
...
Tom,
I ran into a problem. Do you mean copy the data from the existing
"Text-type" column to the new "number-type" colum i've just created?
Because
if that is the case, I tried to do that and i got an error, "the value you
entered isnt valid for this field"
Thank you

"Tom Ellison" wrote:

Dear Bigo:

To save yourself from losing anything, create a new column for Time
with the
desired datatype. Update that with the existing time values and make
sure
it comes through properly. Keep the old one around until you're sure
you
don't need it anymore.

I'm not getting into what else you have here, at least not yet. I just
wanted to get this suggestion to you promptly.

Tom Ellison


"bigo" wrote in message
...
It looks like I have labeled the Time Field in my table as "text"
rather
than
"Number". Now if I am to change it to Number.. it will screw up my
database
of like 200 entries. Is there a way to fix this without screwing up
my
data?
Thank you


"bigo" wrote:

Hi guys,

I've done an extensive search for this, and found similar problems,
but
nothing spesific to Short Time that helped me.
I have a database- one table consists of two columns : Associate ID
and
Time
. There is no primary key.
I generated a report, The Associate ID being the one and only
grouping
level. So the report will show me teh Associate ID, and underneath
it it
will
list all the recorded times for the assocaite it will look something
like
this :

***************************
Assocaite ID abc0101
Time
01:00
00:05
00:30
Associate ID sam0556
Time
00:06
00:10
00:30

********************************
...and so on
What I want to do is to be able to add in my report the Total time
(SUM)
of
all the individaul times per associate. I was unsuccessful with many
time
putting =Sum([Time]) in the page header and other places. Most of
the
time I
get #error
Please Help!! However , I am an NEWBIe, so please try to give me the
easiest
solution.Thank you

If the field is truly a text type field, you should be able to convert it to
the number of minutes by using an expression like:
CDate([TimeFieldName]) * 1440

--
Duane Hookom
MS Access MVP
--

"bigo" wrote in message
...
Ok. Here is my problem. I have a database of time for associates. By time,
what I really mean is the number of minutes the associate has worked. For
example if associate abc worked 5 minutes, i entered it in "short time" as
00:05. If associate xyz worked for 1 hour, it was inputed as 01:00. Now
from
reading other threads, it appears I should not have used Short Time. To
add
to this big mess, the column, that has all the times ( in short time
format)
is set up as "text" data type.

So, What I aim to achieve is to convert this column data type from text to
number. However, I guess I must first some how convert the format -being
"Short time" to hours and minutes.
Hope this clears it up a little.
Thank you again.

"Tom Ellison" wrote:

Dear Bigo:

OK. The column from which you are copying is text, and contains a colon.
Right?

The column to which you're copying this is what?

If it is datetime, then convert the text data to datetime using CDate().
Don't past it in. Write an update query to do it.

Any better? If not, give details of what is being done, and what is
wrong.

Tom Ellison


"bigo" wrote in message
...
Tom,
I ran into a problem. Do you mean copy the data from the existing
"Text-type" column to the new "number-type" colum i've just created?
Because
if that is the case, I tried to do that and i got an error, "the value
you
entered isnt valid for this field"
Thank you

"Tom Ellison" wrote:

Dear Bigo:

To save yourself from losing anything, create a new column for Time
with the
desired datatype. Update that with the existing time values and
make
sure
it comes through properly. Keep the old one around until you're
sure
you
don't need it anymore.

I'm not getting into what else you have here, at least not yet. I
just
wanted to get this suggestion to you promptly.

Tom Ellison


"bigo" wrote in message
...
It looks like I have labeled the Time Field in my table as "text"
rather
than
"Number". Now if I am to change it to Number.. it will screw up my
database
of like 200 entries. Is there a way to fix this without screwing
up
my
data?
Thank you


"bigo" wrote:

Hi guys,

I've done an extensive search for this, and found similar
problems,
but
nothing spesific to Short Time that helped me.
I have a database- one table consists of two columns : Associate
ID
and
Time
. There is no primary key.
I generated a report, The Associate ID being the one and only
grouping
level. So the report will show me teh Associate ID, and
underneath
it it
will
list all the recorded times for the assocaite it will look
something
like
this :

***************************
Assocaite ID abc0101
Time
01:00
00:05
00:30
Associate ID sam0556
Time
00:06
00:10
00:30

********************************
...and so on
What I want to do is to be able to add in my report the Total
time
(SUM)
of
all the individaul times per associate. I was unsuccessful with
many
time
putting =Sum([Time]) in the page header and other places. Most of
the
time I
get #error
Please Help!! However , I am an NEWBIe, so please try to give me
the
easiest
solution.Thank you

Duane,
I am a newbie to access. Where do I put that expression ?!
Thank you so much

"Duane Hookom" wrote:

If the field is truly a text type field, you should be able to convert it to
the number of minutes by using an expression like:
CDate([TimeFieldName]) * 1440

--
Duane Hookom
MS Access MVP
--

"bigo" wrote in message
...
Ok. Here is my problem. I have a database of time for associates. By time,
what I really mean is the number of minutes the associate has worked. For
example if associate abc worked 5 minutes, i entered it in "short time" as
00:05. If associate xyz worked for 1 hour, it was inputed as 01:00. Now
from
reading other threads, it appears I should not have used Short Time. To
add
to this big mess, the column, that has all the times ( in short time
format)
is set up as "text" data type.

So, What I aim to achieve is to convert this column data type from text to
number. However, I guess I must first some how convert the format -being
"Short time" to hours and minutes.
Hope this clears it up a little.
Thank you again.

"Tom Ellison" wrote:

Dear Bigo:

OK. The column from which you are copying is text, and contains a colon.
Right?

The column to which you're copying this is what?

If it is datetime, then convert the text data to datetime using CDate().
Don't past it in. Write an update query to do it.

Any better? If not, give details of what is being done, and what is
wrong.

Tom Ellison


"bigo" wrote in message
...
Tom,
I ran into a problem. Do you mean copy the data from the existing
"Text-type" column to the new "number-type" colum i've just created?
Because
if that is the case, I tried to do that and i got an error, "the value
you
entered isnt valid for this field"
Thank you

"Tom Ellison" wrote:

Dear Bigo:

To save yourself from losing anything, create a new column for Time
with the
desired datatype. Update that with the existing time values and
make
sure
it comes through properly. Keep the old one around until you're
sure
you
don't need it anymore.

I'm not getting into what else you have here, at least not yet. I
just
wanted to get this suggestion to you promptly.

Tom Ellison


"bigo" wrote in message
...
It looks like I have labeled the Time Field in my table as "text"
rather
than
"Number". Now if I am to change it to Number.. it will screw up my
database
of like 200 entries. Is there a way to fix this without screwing
up
my
data?
Thank you


"bigo" wrote:

Hi guys,

I've done an extensive search for this, and found similar
problems,
but
nothing spesific to Short Time that helped me.
I have a database- one table consists of two columns : Associate
ID
and
Time
. There is no primary key.
I generated a report, The Associate ID being the one and only
grouping
level. So the report will show me teh Associate ID, and
underneath
it it
will
list all the recorded times for the assocaite it will look
something
like
this :

***************************
Assocaite ID abc0101
Time
01:00
00:05
00:30
Associate ID sam0556
Time
00:06
00:10
00:30

********************************
...and so on
What I want to do is to be able to add in my report the Total
time
(SUM)
of
all the individaul times per associate. I was unsuccessful with
many
time
putting =Sum([Time]) in the page header and other places. Most of
the
time I
get #error
Please Help!! However , I am an NEWBIe, so please try to give me
the
easiest
solution.Thank you

Ok.. I'm kind of getting somewhere but one thing :
CDate([TimeFieldName]) * 1440 will convert the time in minutes for example:
instead of 01:10 it will make it to 70 minutes. But I want it in hours and
minutes i.e. 1 hr 10 min ?

"Duane Hookom" wrote:

If the field is truly a text type field, you should be able to convert it to
the number of minutes by using an expression like:
CDate([TimeFieldName]) * 1440

--
Duane Hookom
MS Access MVP
--

"bigo" wrote in message
...
Ok. Here is my problem. I have a database of time for associates. By time,
what I really mean is the number of minutes the associate has worked. For
example if associate abc worked 5 minutes, i entered it in "short time" as
00:05. If associate xyz worked for 1 hour, it was inputed as 01:00. Now
from
reading other threads, it appears I should not have used Short Time. To
add
to this big mess, the column, that has all the times ( in short time
format)
is set up as "text" data type.

So, What I aim to achieve is to convert this column data type from text to
number. However, I guess I must first some how convert the format -being
"Short time" to hours and minutes.
Hope this clears it up a little.
Thank you again.

"Tom Ellison" wrote:

Dear Bigo:

OK. The column from which you are copying is text, and contains a colon.
Right?

The column to which you're copying this is what?

If it is datetime, then convert the text data to datetime using CDate().
Don't past it in. Write an update query to do it.

Any better? If not, give details of what is being done, and what is
wrong.

Tom Ellison


"bigo" wrote in message
...
Tom,
I ran into a problem. Do you mean copy the data from the existing
"Text-type" column to the new "number-type" colum i've just created?
Because
if that is the case, I tried to do that and i got an error, "the value
you
entered isnt valid for this field"
Thank you

"Tom Ellison" wrote:

Dear Bigo:

To save yourself from losing anything, create a new column for Time
with the
desired datatype. Update that with the existing time values and
make
sure
it comes through properly. Keep the old one around until you're
sure
you
don't need it anymore.

I'm not getting into what else you have here, at least not yet. I
just
wanted to get this suggestion to you promptly.

Tom Ellison


"bigo" wrote in message
...
It looks like I have labeled the Time Field in my table as "text"
rather
than
"Number". Now if I am to change it to Number.. it will screw up my
database
of like 200 entries. Is there a way to fix this without screwing
up
my
data?
Thank you


"bigo" wrote:

Hi guys,

I've done an extensive search for this, and found similar
problems,
but
nothing spesific to Short Time that helped me.
I have a database- one table consists of two columns : Associate
ID
and
Time
. There is no primary key.
I generated a report, The Associate ID being the one and only
grouping
level. So the report will show me teh Associate ID, and
underneath
it it
will
list all the recorded times for the assocaite it will look
something
like
this :

***************************
Assocaite ID abc0101
Time
01:00
00:05
00:30
Associate ID sam0556
Time
00:06
00:10
00:30

********************************
...and so on
What I want to do is to be able to add in my report the Total
time
(SUM)
of
all the individaul times per associate. I was unsuccessful with
many
time
putting =Sum([Time]) in the page header and other places. Most of
the
time I
get #error
Please Help!! However , I am an NEWBIe, so please try to give me
the
easiest
solution.Thank you