Query not pulling from Main Table

[Guest]

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!!

 

[Lynn Trapp]

You're going to need to post the SQL for the query before anyone can help
you figure it out.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Guest]

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;

 

[Lynn Trapp]

Well, to start with, you do not have a join statement in your query. When
you view the query in the QBE grid, is there a line joining the boxes for
the 2 tables?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html