Bad news, I cannot follow your explanation. Good news, I don't need to--I just need to see data. Let's focus on issue #1 for now. Provide 2 sets of data:
A. Starting sample data from your table(s). Provide table and field names and enough sample data to cover all cases.
B. Expected results when you feed in the data from A. Show me what data you expect to end up with when you feed the data from A into this yet to be built query.
Again, no explanations needed, just data--2 sets beginning and ending.
I'm lost. Is that both issues or just issue #1 like I asked? Because each file you sent has tblExpected. You have 2 expected data sets in there.
Again, let's focus on one issue. What exactly am I looking at in each file?
For Issue #1, run query "qry3PartTrans", try adding other numbers to see if you still get the correct result!
Now its explanation time.
Why is B_Number=3465175627 not in the expected results?
SELECT tblGeneral.B_Number, tblGeneral.A_Number
FROM tblGeneral
GROUP BY tblGeneral.B_Number, tblGeneral.A_Number;
SELECT Mutual_sub1.B_Number
FROM Mutual_sub1
GROUP BY Mutual_sub1.B_Number
HAVING (((Count(Mutual_sub1.A_Number))>1));
TRANSFORM Count(tblGeneral.A_Number) AS CountOfA_Number
SELECT tblGeneral.B_Number
FROM tblGeneral INNER JOIN Mutual_sub2 ON tblGeneral.B_Number = Mutual_sub2.B_Number
GROUP BY tblGeneral.B_Number
PIVOT tblGeneral.A_Number;
SELECT tblConference.*, iif(tblConference.Call_Start_DateTime<tblConference_1.Call_Start_DateTime, tblConference.Call_Start_DateTime, tblConference_1.Call_Start_DateTime) AS InitialCall
FROM tblConference INNER JOIN tblConference AS tblConference_1 ON (tblConference.Call_End_DateTime>=tblConference_1.Call_Start_DateTime) AND (tblConference.Call_Start_DateTime<=tblConference_1.Call_End_DateTime) AND (tblConference.A_Number = tblConference_1.A_Number)
WHERE tblConference.B_Number <> tblConference_1.B_Number;
SELECT OverlappedCalls_sub1.A_Number, OverlappedCalls_sub1.B_Number, OverlappedCalls_sub1.Call_Type, OverlappedCalls_sub1.Call_Start_DateTime, OverlappedCalls_sub1.Call_End_DateTime, OverlappedCalls_sub1.Duration, IIf([tblConference].[Call_Type]="Out-Call","Call-Waiting","Call-Conference") AS Result
FROM OverlappedCalls_sub1 INNER JOIN tblConference ON (OverlappedCalls_sub1.InitialCall = tblConference.Call_Start_DateTime) AND (OverlappedCalls_sub1.A_Number = tblConference.A_Number)
GROUP BY OverlappedCalls_sub1.A_Number, OverlappedCalls_sub1.B_Number, OverlappedCalls_sub1.Call_Type, OverlappedCalls_sub1.Call_Start_DateTime, OverlappedCalls_sub1.Call_End_DateTime, OverlappedCalls_sub1.Duration, IIf([tblConference].[Call_Type]="Out-Call","Call-Waiting","Call-Conference");
Your welcome. No donation needed.