Create a report from two unrelated sources


D

Dmackcwby

I currently work in a call center and I have a data base that logs all all
escalated calls. I'm trying to create a report from a query and a table that
are unrelated. The table lists the total number of calls that was offered to
our escalation queue.

The fields are
EscVolId, Date, and Count

The queries SQL is this:

SELECT Format(tblEscTrack.OpnDate,"mm") AS [Month],
Format(tblEscTrack.OpnDate,"mmmm") AS Month2, tblEscTrack.OpnDate,
tblEscTrack.TrackID, tblEscTrack.EstDate, tblEscTrack.ClsDate,
IIf(tblEscTrack.ClsYN=No,1,0) AS [No], IIf(tblEscTrack.ClsYN=Yes,1,0) AS Yes,
IIf((tblEscTrack.ClsDate Is Null) And
(Date()>(DateAdd("d",+5,tblEscTrack.EstDate))),1,0) AS LateCount,
IIf(((tblEscTrack.ClsDate Is Null) And
(Date()>=(DateAdd("d",+5,tblEscTrack.EstDate)) And (tblEscTrack.ClsDate Is
Null) And (Date()<(DateAdd("d",+10,tblEscTrack.EstDate))))),1,0) AS
LateCount510, IIf(((tblEscTrack.ClsDate Is Null) And
(Date()>=(DateAdd("d",+10,tblEscTrack.EstDate)) And (tblEscTrack.ClsDate Is
Null) And (Date()<(DateAdd("d",+15,tblEscTrack.EstDate))))),1,0) AS
LateCount1015, IIf(((tblEscTrack.ClsDate Is Null) And
(Date()>=(DateAdd("d",+15,tblEscTrack.EstDate)))),1,0) AS LateCount15Plus
FROM tblFsEscRep INNER JOIN (tblEscReason INNER JOIN (tblEscCust INNER JOIN
tblEscTrack ON tblEscCust.EscCustID = tblEscTrack.EscCustID) ON
tblEscReason.EscReasonID = tblEscTrack.EscReason) ON tblFsEscRep.FsEscID =
tblEscTrack.EscRepID
ORDER BY Format(tblEscTrack.OpnDate,"mm"), tblEscTrack.OpnDate,
tblEscTrack.TrackID;

The only field that might possible relate is the date field. However, the
table has the date field once with an over all count for the day. The query
will have the date in multiple times for each enter. If I try to combine the
information in a query I get false that are extremely over exagerated.

What I'm looking to do in the report is list the total calls offer to the
queue and be able to figure a percentage of calls entered into the database.
I don't know if this can be done since the sources are unrelated. Can anyone
help?
 
Ad

Advertisements

K

Klatuu

Use a Report/SubReport and use the call dates from both for the Link
Master/Link Child properties in the subreport control.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top