Create a report from two unrelated sources

  • Thread starter Thread starter Dmackcwby
  • Start date Start date
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?
 
Use a Report/SubReport and use the call dates from both for the Link
Master/Link Child properties in the subreport control.
 
Back
Top