The error message is correct...look at your FROM:

FROM ((tblApVendor INNER JOIN tblApHistHeader ON tblApVendor.VendorID = tblApHistHeader.VendorId)

   INNER JOIN tblApCheckHist ON (tblApHistHeader.InvoiceDate = tblApCheckHist.InvoiceDate)

       AND (tblApHistHeader.InvoiceNum = tblApCheckHist.InvoiceNum)

       AND (tblApHistHeader.VendorId = tblApCheckHist.VendorID))

   INNER JOIN (tblApHistDetail INNER JOIN tblGlAcctHdr ON tblApHistDetail.GLAcct = tblGlAcctHdr.AcctId)

    ON tblApHistHeader.TransId = tblApHistDetail.TransID

There's no table or table alias as Forms.frmImPrintPmtAdvice

So, what is Forms.frmImPrintPmtAdvice? That looks like an ACCESS description which doesn't exist in SQL Server.

-SQLBill