Duplicate Query Results

  • Thread starter Thread starter Rudy
  • Start date Start date
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
 
Quadrupling of results is usually of sign of joining tables in a many-many
relationship.

I suggest you copy the data into Access tables (for testing) and write
various small queries to give tyou the result you are looking for. You can
base subsequent queries on previous queries to help you get there in a few
steps.
I recall stack queires 7 high many years ago to get the final result. Just
because some genius could write it in one huge SQL command doesn't mean we
have to aim for that goal. Take many small steps to get the same anwser.
 
Back
Top