Phone call log, multiple fields for different times

Hello,
I'm having trouble coming up with a way to do this...and I think there
should be a way but I've been unable to figure out whether relationships and
multiple tables do what I need. I've read through a couple of tutorials on
the office site and they don't cover something like this.

Ok, onto the problem. I've got some data that is basically a phone call
log for a specific date. Each date has different times that the calls were
received for every half an hour.
I believe I should define the primary key in the table as the date...but
I'm lost after that.

There are 3 additional values that count towards the times. Here's a
sample of the data if it helps:

Time Avg Ans Speed # of Calls Avg talk time
6:00am - 6:30 am :07 5 :11
....
....
10:30pm-11:00pm

The problem is, there are so many time fields, and 3 additional values that
are specifically related to the time for that specific date.
I've already got a way to enter the times in via a scripting program for the
fields, but I don't know how to set up the tables or forms.

Thanks for any help that can be offered.

Philip

I can't quite visualize your "call log"'s data structure. Are you saying
that you have a table with rows that are specific to a time period (e.g.,
6:00am - 6:30am)? That sounds like a ... spreadsheet!

If you log your calls when they come in (e.g., 4/20/2006 6:13:00 AM) by
using the Now() function, you can always divide them up into half-hour
blocks using queries and reports.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/


"Philip" wrote in message
...
Hello,
I'm having trouble coming up with a way to do this...and I think there
should be a way but I've been unable to figure out whether relationships
and
multiple tables do what I need. I've read through a couple of tutorials
on
the office site and they don't cover something like this.

Ok, onto the problem. I've got some data that is basically a phone call
log for a specific date. Each date has different times that the calls
were
received for every half an hour.
I believe I should define the primary key in the table as the date...but
I'm lost after that.

There are 3 additional values that count towards the times. Here's a
sample of the data if it helps:

Time Avg Ans Speed # of Calls Avg talk time
6:00am - 6:30 am :07 5 :11
...
...
10:30pm-11:00pm

The problem is, there are so many time fields, and 3 additional values
that
are specifically related to the time for that specific date.
I've already got a way to enter the times in via a scripting program for
the
fields, but I don't know how to set up the tables or forms.

Thanks for any help that can be offered.

Jeff,
They are listed in half hour blocks from 6am-11pm. The page I get is
actually a report from the phone system that prints out for every day. I've
been given the responsibility to log this data to a file so that a pivot
table can be used to show which days/times are busiest.
I did manage to make a spreadsheet, with three different tabs-one for each
piece of data that needs to be entered, and with the half hour blocks going
across the top columns. I was not able to previously visuallize a way to get
all the data into a file until reading about access and separating the data
into different tables. Setting up the access tables for so many fields and
creating a nice looking form to put the data in was too much. I've settled
down on the spreadsheet format I think. But if there is a better way to use
access, I would be able to import the data one way or another back into a
database.

Thank you for the response,
Philip

"Jeff Boyce" wrote:

Philip

I can't quite visualize your "call log"'s data structure. Are you saying
that you have a table with rows that are specific to a time period (e.g.,
6:00am - 6:30am)? That sounds like a ... spreadsheet!

If you log your calls when they come in (e.g., 4/20/2006 6:13:00 AM) by
using the Now() function, you can always divide them up into half-hour
blocks using queries and reports.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/


"Philip" wrote in message
...
Hello,
I'm having trouble coming up with a way to do this...and I think there
should be a way but I've been unable to figure out whether relationships
and
multiple tables do what I need. I've read through a couple of tutorials
on
the office site and they don't cover something like this.

Ok, onto the problem. I've got some data that is basically a phone call
log for a specific date. Each date has different times that the calls
were
received for every half an hour.
I believe I should define the primary key in the table as the date...but
I'm lost after that.

There are 3 additional values that count towards the times. Here's a
sample of the data if it helps:

Time Avg Ans Speed # of Calls Avg talk time
6:00am - 6:30 am :07 5 :11
...
...
10:30pm-11:00pm

The problem is, there are so many time fields, and 3 additional values
that
are specifically related to the time for that specific date.
I've already got a way to enter the times in via a scripting program for
the
fields, but I don't know how to set up the tables or forms.

Thanks for any help that can be offered.

Philip

It would help if I could see an example of the data as you receive it.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/


"Philip" wrote in message
...
Jeff,
They are listed in half hour blocks from 6am-11pm. The page I get is
actually a report from the phone system that prints out for every day.
I've
been given the responsibility to log this data to a file so that a pivot
table can be used to show which days/times are busiest.
I did manage to make a spreadsheet, with three different tabs-one for
each
piece of data that needs to be entered, and with the half hour blocks
going
across the top columns. I was not able to previously visuallize a way to
get
all the data into a file until reading about access and separating the
data
into different tables. Setting up the access tables for so many fields
and
creating a nice looking form to put the data in was too much. I've
settled
down on the spreadsheet format I think. But if there is a better way to
use
access, I would be able to import the data one way or another back into a
database.

Thank you for the response,
Philip

"Jeff Boyce" wrote:

Philip

I can't quite visualize your "call log"'s data structure. Are you
saying
that you have a table with rows that are specific to a time period
(e.g.,
6:00am - 6:30am)? That sounds like a ... spreadsheet!

If you log your calls when they come in (e.g., 4/20/2006 6:13:00 AM) by
using the Now() function, you can always divide them up into half-hour
blocks using queries and reports.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/


"Philip" wrote in message
...
Hello,
I'm having trouble coming up with a way to do this...and I think
there
should be a way but I've been unable to figure out whether
relationships
and
multiple tables do what I need. I've read through a couple of
tutorials
on
the office site and they don't cover something like this.

Ok, onto the problem. I've got some data that is basically a phone
call
log for a specific date. Each date has different times that the calls
were
received for every half an hour.
I believe I should define the primary key in the table as the
date...but
I'm lost after that.

There are 3 additional values that count towards the times. Here's a
sample of the data if it helps:

Time Avg Ans Speed # of Calls Avg talk
time
6:00am - 6:30 am :07 5
:11
...
...
10:30pm-11:00pm

The problem is, there are so many time fields, and 3 additional values
that
are specifically related to the time for that specific date.
I've already got a way to enter the times in via a scripting program
for
the
fields, but I don't know how to set up the tables or forms.

Thanks for any help that can be offered.

The data I receive is formatted like follows:

Time Avg Speed Ans ACD Calls Avg Talk Time
6:00-6:30 AM :07 1 :11
6:30-7:00 AM :05 4 :33
...
10:30-11:00 PM .. .. ..

I only properly format the time values on Avg Talk Time, as the answer time
will never go higher than about 10-15 seconds.

"Jeff Boyce" wrote:

Philip

It would help if I could see an example of the data as you receive it.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/


"Philip" wrote in message
...
Jeff,
They are listed in half hour blocks from 6am-11pm. The page I get is
actually a report from the phone system that prints out for every day.
I've
been given the responsibility to log this data to a file so that a pivot
table can be used to show which days/times are busiest.
I did manage to make a spreadsheet, with three different tabs-one for
each
piece of data that needs to be entered, and with the half hour blocks
going
across the top columns. I was not able to previously visuallize a way to
get
all the data into a file until reading about access and separating the
data
into different tables. Setting up the access tables for so many fields
and
creating a nice looking form to put the data in was too much. I've
settled
down on the spreadsheet format I think. But if there is a better way to
use
access, I would be able to import the data one way or another back into a
database.

Thank you for the response,
Philip

"Jeff Boyce" wrote:

Philip

I can't quite visualize your "call log"'s data structure. Are you
saying
that you have a table with rows that are specific to a time period
(e.g.,
6:00am - 6:30am)? That sounds like a ... spreadsheet!

If you log your calls when they come in (e.g., 4/20/2006 6:13:00 AM) by
using the Now() function, you can always divide them up into half-hour
blocks using queries and reports.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/


"Philip" wrote in message
...
Hello,
I'm having trouble coming up with a way to do this...and I think
there
should be a way but I've been unable to figure out whether
relationships
and
multiple tables do what I need. I've read through a couple of
tutorials
on
the office site and they don't cover something like this.

Ok, onto the problem. I've got some data that is basically a phone
call
log for a specific date. Each date has different times that the calls
were
received for every half an hour.
I believe I should define the primary key in the table as the
date...but
I'm lost after that.

There are 3 additional values that count towards the times. Here's a
sample of the data if it helps:

Time Avg Ans Speed # of Calls Avg talk
time
6:00am - 6:30 am :07 5
:11
...
...
10:30pm-11:00pm

The problem is, there are so many time fields, and 3 additional values
that
are specifically related to the time for that specific date.
I've already got a way to enter the times in via a scripting program
for
the
fields, but I don't know how to set up the tables or forms.

Thanks for any help that can be offered.

Philip

A couple observations ...

If you are actually receiving the "6:00-6:30 AM" text string, I see neither
an exact time nor a date. How do you keep track of which date, if this is
important?

I noticed that you get a text string which contains numbers whose labels
appear to indicate that they are averaged values. "Doing the math" on
averages is a little different than doing the math on raw numbers.

And you'll need to convert those text strings to actual numbers before doing
any math ... the string ":33" contains digits, but isn't a number. You'll
need to work out a way to parse out the seconds and minutes (?and hours) and
convert them to the lowest unit of measure you need (I'll guess seconds).
For instance, if you received "1:03", you'd need to parse this to a number
= 63. Once you have the number/value, you can begin considering how you'd
do math (carefully! see above).

If, when you're all done with your math, you want to present a "time" in
hh:nn:ss format, you'll also need to work out the routines you'll use to
parse a number like 2350 (a total number of seconds) into its hh:nn:ss
representation (I believe "39:10", but my math might be off).

--
Regards

Jeff Boyce
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/


"Philip" wrote in message
...
The data I receive is formatted like follows:

Time Avg Speed Ans ACD Calls Avg Talk Time
6:00-6:30 AM :07 1 :11
6:30-7:00 AM :05 4 :33
..
10:30-11:00 PM .. .. ..

I only properly format the time values on Avg Talk Time, as the answer
time
will never go higher than about 10-15 seconds.

"Jeff Boyce" wrote:

Philip

It would help if I could see an example of the data as you receive it.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/


"Philip" wrote in message
...
Jeff,
They are listed in half hour blocks from 6am-11pm. The page I get
is
actually a report from the phone system that prints out for every day.
I've
been given the responsibility to log this data to a file so that a
pivot
table can be used to show which days/times are busiest.
I did manage to make a spreadsheet, with three different tabs-one
for
each
piece of data that needs to be entered, and with the half hour blocks
going
across the top columns. I was not able to previously visuallize a way
to
get
all the data into a file until reading about access and separating the
data
into different tables. Setting up the access tables for so many
fields
and
creating a nice looking form to put the data in was too much. I've
settled
down on the spreadsheet format I think. But if there is a better way
to
use
access, I would be able to import the data one way or another back
into a
database.

Thank you for the response,
Philip

"Jeff Boyce" wrote:

Philip

I can't quite visualize your "call log"'s data structure. Are you
saying
that you have a table with rows that are specific to a time period
(e.g.,
6:00am - 6:30am)? That sounds like a ... spreadsheet!

If you log your calls when they come in (e.g., 4/20/2006 6:13:00 AM)
by
using the Now() function, you can always divide them up into
half-hour
blocks using queries and reports.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/


"Philip" wrote in message
...
Hello,
I'm having trouble coming up with a way to do this...and I
think
there
should be a way but I've been unable to figure out whether
relationships
and
multiple tables do what I need. I've read through a couple of
tutorials
on
the office site and they don't cover something like this.

Ok, onto the problem. I've got some data that is basically a
phone
call
log for a specific date. Each date has different times that the
calls
were
received for every half an hour.
I believe I should define the primary key in the table as the
date...but
I'm lost after that.

There are 3 additional values that count towards the times.
Here's a
sample of the data if it helps:

Time Avg Ans Speed # of Calls Avg
talk
time
6:00am - 6:30 am :07 5
:11
...
...
10:30pm-11:00pm

The problem is, there are so many time fields, and 3 additional
values
that
are specifically related to the time for that specific date.
I've already got a way to enter the times in via a scripting
program
for
the
fields, but I don't know how to set up the tables or forms.

Thanks for any help that can be offered.