Query not pulling from Main Table

D

Doug_C

Hello,

I a Main form (QC) and a Subform (QCErrors) linked by Loan Number.
Everything works fine and all info is being stored in their respective
tables. However, when I try to run a query for the information, only the
records with info in both the Main form AND Subform show. If no information
is in the Subform, it doesn't show in the query. What did I do wrong?

Thanks!!
 
D

Doug_C

Here is what the query says:
SELECT tblQC.QCBy, tblQC.CurrentDate, tblQC.CIF, tblQC.LnNumber,
tblQC.LastName, tblQC.FirstName, tblQC.BatchType, tblQC.BatchName,
tblQCErrors.ProcName, tblQCErrors.ErrType, tblQCErrors.ErrOcc
FROM tblQC, tblQCErrors
ORDER BY tblQC.QCBy, tblQC.LnNumber;
 
Top