MS SQL Server SQL syntax vs Access SQL syntax question??

I have the folliwing syntax for a query that works in MS Access, however, when I use it on the
same database converted to MS SQL Server, it does not work. Could some check the syntax and
tell if it is compatible with MS SQL Server.

Thank You

SELECT tblAPCheckbook.strPayee, "AP-Bill" AS Source, [strVendorOrderNumber] & " " & tblAPBill.strReference & " " & tblApBillDetail!memdescription AS NewComment, tblAPCheckbook.dtmDate, tblAPCheckbook.strNum, tblAPBillDetail.strJobID, Sum(tblAPBillDetail.curCost) AS SumOfcurCost, tblAPBillDetail.cntID
FROM tblAPBill INNER JOIN ((tblAPCheckbook INNER JOIN tblAPPayment ON tblAPCheckbook.strNum = tblAPPayment.strPaymentInfo) INNER JOIN (tblAPPaymentDetail INNER JOIN tblAPBillDetail ON tblAPPaymentDetail.strOrderNumber = tblAPBillDetail.strOrderNumber) ON tblAPPayment.strPayableID = tblAPPaymentDetail.strPayableID) ON tblAPBill.strOrderNumber = tblAPBillDetail.strOrderNumber
WHERE (((tblAPCheckbook.ysnPosted)=-1) AND ((tblAPCheckbook.ysnVoid)=0) AND ((tblAPCheckbook.dtmDate) Between [forms]![frmSmReport]![zstxtFromdate] And [forms]![frmSmReport]![zsTxtTodate]) AND ((tblAPPaymentDetail.curPayment)<>0))
GROUP BY tblAPCheckbook.strPayee, "AP-Bill", [strVendorOrderNumber] & " " & tblAPBill.strReference & " " & tblApBillDetail!memdescription, tblAPCheckbook.dtmDate, tblAPCheckbook.strNum, tblAPBillDetail.strJobID, tblAPBillDetail.cntID
HAVING (((tblAPBillDetail.strJobID) Is Not Null));

You will discover that Access and MS SQL Server are not very compatible at all.

Your query should look along the lines of this, you just need to add the correct values and use your INNER JOINS properly.

Thank You for the response. It turns out the following "(tblAPCheckbook.ysnPosted = -1)"
is based on a "Yes/No" field. Access seemed to have no problem with using -1 but I guess MS SQL Server was not happy.

Thanks Again

A bit field won't support a signed value like -1
You can change the column datatype to tinyint, or the value to 1