K
KevinS
Below is the code for a query I am running. For some reason every records is
coming out twice.
I have even gone so far as to eliminate one field at a time and still get
the same results. Can you tell me why it is repeating and what I can about
it to prevent it from happening again.
Thank you,
Kevin
SELECT IntakeMain.ReferDate, IntakeMain.KLName, IntakeMain.KFName,
IntakeMain.[In Home] AS Expr1, [Individual Clearances].ID, [Individual
Clearances].DueDate, [Individual Clearances].SentDate, [Individual
Clearances].RecDate, [Individual Clearances].Comments
FROM (IntakeKinship INNER JOIN ((IntakeMain LEFT JOIN [frmsrc Caregivers and
Kin] ON IntakeMain.KSSN = [frmsrc Caregivers and Kin].KSSN) INNER JOIN
IntakeChild ON IntakeMain.CaseID = IntakeChild.CaseID) ON IntakeKinship.KSSN
= IntakeMain.KSSN) INNER JOIN [Individual Clearances] ON IntakeMain.KSSN =
[Individual Clearances].KSSN
WHERE ((([Individual Clearances].DueDate)>#1/1/2006#));
coming out twice.
I have even gone so far as to eliminate one field at a time and still get
the same results. Can you tell me why it is repeating and what I can about
it to prevent it from happening again.
Thank you,
Kevin
SELECT IntakeMain.ReferDate, IntakeMain.KLName, IntakeMain.KFName,
IntakeMain.[In Home] AS Expr1, [Individual Clearances].ID, [Individual
Clearances].DueDate, [Individual Clearances].SentDate, [Individual
Clearances].RecDate, [Individual Clearances].Comments
FROM (IntakeKinship INNER JOIN ((IntakeMain LEFT JOIN [frmsrc Caregivers and
Kin] ON IntakeMain.KSSN = [frmsrc Caregivers and Kin].KSSN) INNER JOIN
IntakeChild ON IntakeMain.CaseID = IntakeChild.CaseID) ON IntakeKinship.KSSN
= IntakeMain.KSSN) INNER JOIN [Individual Clearances] ON IntakeMain.KSSN =
[Individual Clearances].KSSN
WHERE ((([Individual Clearances].DueDate)>#1/1/2006#));