sum of "Short Time" Column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 said:
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 said:
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
Click to expand...
Click to expand...
 
Tom,
It sounds like a great suggestion, and I sincerely appreciate your prompt
response.
I will attempt that.

Tom Ellison said:
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 said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
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


:

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
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
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


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


:

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
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
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
:

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


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


:

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
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
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

:

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


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


:

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
Click to expand...
Click to expand...
Click to expand...
 
Duane,
I am a newbie to access. Where do I put that expression ?!
Thank you so much

Duane Hookom said:
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 said:
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 said:
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


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

:

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


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


:

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
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
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


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

:

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


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


:

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
Click to expand...
Click to expand...
Click to expand...
 
You can use the expression in a control source of a text box
=CDate([TimeFieldName]) * 1440
or to create a new column in a query
NumOfMinutes: CDate([TimeFieldName]) * 1440
or in an update query
Update tblYourTable
Set NumOfMinutes = CDate([TimeFieldName]) * 1440;

--
Duane Hookom
MS Access MVP
--

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

Duane Hookom said:
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 said:
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.

:

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


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

:

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


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


:

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
Click to expand...
Click to expand...
Click to expand...
 
There are lots of examples of this type of display in these news groups.
Doug Steele has a link to a function from his page
http://www.accessmvp.com/djsteele/AccessIndex.html.

If all you want is a true date/time value, remove the "* 1440".

Personally I would want to see the result in the number of minutes or hours
with decimals.

--
Duane Hookom
MS Access MVP
--

bigo said:
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 said:
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 said:
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.

:

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


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

:

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


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


:

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
Click to expand...
Click to expand...
Click to expand...
 
Ok. See when i remove the *1440 all I get is it converts my 5 minutes (00:05)
into 12:05AM. it will convert 2 hours (02:00) into 02:00AM.
Ok. What I want to do, is add my hours for example
7:30
2:30
6:00
10:30
and get a sum of 26:30 which is 26 hr and 30 minutes
if I add the *1440 to the expression it will give me the answer ill get an
error for such big number.
if it is a small number like say 1:10 it will give me 70
again the whole reason for this conversion is because my Time Column is set
up as Text -data type vs. number

Duane Hookom said:
There are lots of examples of this type of display in these news groups.
Doug Steele has a link to a function from his page
http://www.accessmvp.com/djsteele/AccessIndex.html.

If all you want is a true date/time value, remove the "* 1440".

Personally I would want to see the result in the number of minutes or hours
with decimals.

--
Duane Hookom
MS Access MVP
--

bigo said:
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 said:
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
--

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.

:

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


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

:

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


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


:

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
Click to expand...
Click to expand...
Click to expand...
 
Is there a way i can upload or email you the file to take a look at?
Thank you

bigo said:
Ok. See when i remove the *1440 all I get is it converts my 5 minutes (00:05)
into 12:05AM. it will convert 2 hours (02:00) into 02:00AM.
Ok. What I want to do, is add my hours for example
7:30
2:30
6:00
10:30
and get a sum of 26:30 which is 26 hr and 30 minutes
if I add the *1440 to the expression it will give me the answer ill get an
error for such big number.
if it is a small number like say 1:10 it will give me 70
again the whole reason for this conversion is because my Time Column is set
up as Text -data type vs. number

Duane Hookom said:
There are lots of examples of this type of display in these news groups.
Doug Steele has a link to a function from his page
http://www.accessmvp.com/djsteele/AccessIndex.html.

If all you want is a true date/time value, remove the "* 1440".

Personally I would want to see the result in the number of minutes or hours
with decimals.

--
Duane Hookom
MS Access MVP
--

bigo said:
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 ?

:

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
--

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.

:

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


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

:

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


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


:

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
Click to expand...
Click to expand...
Click to expand...
 
Nope. Did you look at the code from Doug Steele's web site?

--
Duane Hookom
MS Access MVP
--

bigo said:
Is there a way i can upload or email you the file to take a look at?
Thank you

bigo said:
Ok. See when i remove the *1440 all I get is it converts my 5 minutes
(00:05)
into 12:05AM. it will convert 2 hours (02:00) into 02:00AM.
Ok. What I want to do, is add my hours for example
7:30
2:30
6:00
10:30
and get a sum of 26:30 which is 26 hr and 30 minutes
if I add the *1440 to the expression it will give me the answer ill get
an
error for such big number.
if it is a small number like say 1:10 it will give me 70
again the whole reason for this conversion is because my Time Column is
set
up as Text -data type vs. number

Duane Hookom said:
There are lots of examples of this type of display in these news
groups.
Doug Steele has a link to a function from his page
http://www.accessmvp.com/djsteele/AccessIndex.html.

If all you want is a true date/time value, remove the "* 1440".

Personally I would want to see the result in the number of minutes or
hours
with decimals.

--
Duane Hookom
MS Access MVP
--

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 ?

:

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
--

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.

:

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


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

:

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


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


:

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
Click to expand...
Click to expand...
Click to expand...
 
Ya, i did. Give me a few tips,,but that is more towards difference of 2
times, like start time -end time or vice versa. In my case, i just want to
compute the sum of 1 individual column. I havn't been able to do so, because
the data type for that column is "text" instead of "number", and having put
the data in "Short Time" doesnt help, becuase i figured out that Short time
is for time periods and not a number of hours like i though :(

Duane Hookom said:
Nope. Did you look at the code from Doug Steele's web site?

--
Duane Hookom
MS Access MVP
--

bigo said:
Is there a way i can upload or email you the file to take a look at?
Thank you

bigo said:
Ok. See when i remove the *1440 all I get is it converts my 5 minutes
(00:05)
into 12:05AM. it will convert 2 hours (02:00) into 02:00AM.
Ok. What I want to do, is add my hours for example
7:30
2:30
6:00
10:30
and get a sum of 26:30 which is 26 hr and 30 minutes
if I add the *1440 to the expression it will give me the answer ill get
an
error for such big number.
if it is a small number like say 1:10 it will give me 70
again the whole reason for this conversion is because my Time Column is
set
up as Text -data type vs. number

:

There are lots of examples of this type of display in these news
groups.
Doug Steele has a link to a function from his page
http://www.accessmvp.com/djsteele/AccessIndex.html.

If all you want is a true date/time value, remove the "* 1440".

Personally I would want to see the result in the number of minutes or
hours
with decimals.

--
Duane Hookom
MS Access MVP
--

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 ?

:

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
--

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.

:

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


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

:

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


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


:

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
Click to expand...
Click to expand...
Click to expand...
 
1) you were given the function that converts your text into an actual time
value
2) you can sum the calculated time value
3) you can use 0 as a start time and your sum of calculated time as the end
time.

--
Duane Hookom
MS Access MVP
--

bigo said:
Ya, i did. Give me a few tips,,but that is more towards difference of 2
times, like start time -end time or vice versa. In my case, i just want to
compute the sum of 1 individual column. I havn't been able to do so,
because
the data type for that column is "text" instead of "number", and having
put
the data in "Short Time" doesnt help, becuase i figured out that Short
time
is for time periods and not a number of hours like i though :(

Duane Hookom said:
Nope. Did you look at the code from Doug Steele's web site?

--
Duane Hookom
MS Access MVP
--

bigo said:
Is there a way i can upload or email you the file to take a look at?
Thank you

:

Ok. See when i remove the *1440 all I get is it converts my 5 minutes
(00:05)
into 12:05AM. it will convert 2 hours (02:00) into 02:00AM.
Ok. What I want to do, is add my hours for example
7:30
2:30
6:00
10:30
and get a sum of 26:30 which is 26 hr and 30 minutes
if I add the *1440 to the expression it will give me the answer ill
get
an
error for such big number.
if it is a small number like say 1:10 it will give me 70
again the whole reason for this conversion is because my Time Column
is
set
up as Text -data type vs. number

:

There are lots of examples of this type of display in these news
groups.
Doug Steele has a link to a function from his page
http://www.accessmvp.com/djsteele/AccessIndex.html.

If all you want is a true date/time value, remove the "* 1440".

Personally I would want to see the result in the number of minutes
or
hours
with decimals.

--
Duane Hookom
MS Access MVP
--

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 ?

:

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
--

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.

:

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


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

:

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


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


:

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
Click to expand...
Click to expand...
Click to expand...
 
Ok. I appreciate all your help and patience. I will work on it tomorrow, and
I'll let you know how it goes.
Thankx again

Duane Hookom said:
1) you were given the function that converts your text into an actual time
value
2) you can sum the calculated time value
3) you can use 0 as a start time and your sum of calculated time as the end
time.

--
Duane Hookom
MS Access MVP
--

bigo said:
Ya, i did. Give me a few tips,,but that is more towards difference of 2
times, like start time -end time or vice versa. In my case, i just want to
compute the sum of 1 individual column. I havn't been able to do so,
because
the data type for that column is "text" instead of "number", and having
put
the data in "Short Time" doesnt help, becuase i figured out that Short
time
is for time periods and not a number of hours like i though :(

Duane Hookom said:
Nope. Did you look at the code from Doug Steele's web site?

--
Duane Hookom
MS Access MVP
--

Is there a way i can upload or email you the file to take a look at?
Thank you

:

Ok. See when i remove the *1440 all I get is it converts my 5 minutes
(00:05)
into 12:05AM. it will convert 2 hours (02:00) into 02:00AM.
Ok. What I want to do, is add my hours for example
7:30
2:30
6:00
10:30
and get a sum of 26:30 which is 26 hr and 30 minutes
if I add the *1440 to the expression it will give me the answer ill
get
an
error for such big number.
if it is a small number like say 1:10 it will give me 70
again the whole reason for this conversion is because my Time Column
is
set
up as Text -data type vs. number

:

There are lots of examples of this type of display in these news
groups.
Doug Steele has a link to a function from his page
http://www.accessmvp.com/djsteele/AccessIndex.html.

If all you want is a true date/time value, remove the "* 1440".

Personally I would want to see the result in the number of minutes
or
hours
with decimals.

--
Duane Hookom
MS Access MVP
--

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 ?

:

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
--

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.

:

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


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

:

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


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


:

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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top