R
Rudy
Brio is a reporting tool, which I am exporting data into
Access. I
have
created tables based on the Brio Calling List reports.
Each report or
table includes the following fields:
Calling list name
Date(based on the Brio report, in this case 1/1/04-3/31/04)
Begin time (hour)
End time (hour)
Many fields that measure the Calling List, i.e., hit
ratio, wait time,
etc.
There are 10 Calling Lists. I have exported each Calling
List and their
data into their own table. Since each Calling List Table
has their own
time and date, I did not break these fields out into
seperate tables and
create relationships. I also did not draw any
relationships between
each
table. I did allow Access to provide an index field. I
ran a query to
find
the Hit Ratio x date x (4)hours x (2) calling lists.
The date and time fields, I believe, gave me some
trouble. The date in
the
date field is "15-Feb-2004 12 CST". The 12 corresponds to
the hour.
The
begin and end time are "4 PM and 4:59 PM respectively.
I was not able to do a query on just the date field
alone. I had to
incorportate the date and begin time. For the date, I
ended up with
"Like
15-Feb-2004*" and Begin time "4:00 PM OR 5:00 PM OR 6:00
PM OR 7:00 PM"
to
get it to work. However, my result came up with the right
data result, but in
quadruples.
If I used date alone with various times like "Between 15-
Feb=2004 4PM
CST
AND 15-Feb=2004 7PM CST, I would get both AM and PM
times. Anyone have any ideas?
Thanks a bunch,
Rudy
Access. I
have
created tables based on the Brio Calling List reports.
Each report or
table includes the following fields:
Calling list name
Date(based on the Brio report, in this case 1/1/04-3/31/04)
Begin time (hour)
End time (hour)
Many fields that measure the Calling List, i.e., hit
ratio, wait time,
etc.
There are 10 Calling Lists. I have exported each Calling
List and their
data into their own table. Since each Calling List Table
has their own
time and date, I did not break these fields out into
seperate tables and
create relationships. I also did not draw any
relationships between
each
table. I did allow Access to provide an index field. I
ran a query to
find
the Hit Ratio x date x (4)hours x (2) calling lists.
The date and time fields, I believe, gave me some
trouble. The date in
the
date field is "15-Feb-2004 12 CST". The 12 corresponds to
the hour.
The
begin and end time are "4 PM and 4:59 PM respectively.
I was not able to do a query on just the date field
alone. I had to
incorportate the date and begin time. For the date, I
ended up with
"Like
15-Feb-2004*" and Begin time "4:00 PM OR 5:00 PM OR 6:00
PM OR 7:00 PM"
to
get it to work. However, my result came up with the right
data result, but in
quadruples.
If I used date alone with various times like "Between 15-
Feb=2004 4PM
CST
AND 15-Feb=2004 7PM CST, I would get both AM and PM
times. Anyone have any ideas?
Thanks a bunch,
Rudy