I have two queries one is called "QryInfantPending"
SELECT Count(tblInfants.InfantID) AS [Total Infants], IIf(IsNull([tblInfants]![EnrolledDate]),"Pending","Enrolled") AS InfantStatus
GROUP BY IIf(IsNull([tblInfants]![EnrolledDate]),"Pending","Enrolled");
And another one is
SELECT tblScreening.ScreeningDate, Count(tblScreening.MotherID) AS TotalMotherScreened
GROUP BY tblScreening.ScreeningDate;
I was trying to join this query so i can just have one report that would give me result as
What do you use as a WHERE condition in your JOIN? Without a WHERE condition (that defines which record should be JOINed with which other record) every single record will be JOINed with every single other, resulting in a huge number of meaningless data.