Hi All

I have an SQL String which works in SQL Server but not in access

The SQL is as follows:

SELECT TTrnHdrOpenedBy, TTrnHdrTimeStamp, PayNo, PayDescription, TrnPayAmount, TrnMemMember, TTrnDetType
FROM (tblTillTransactionHeader INNER JOIN tblTransactionPayments
ON tblTillTransactionHeader.TTrnHdrTranNo = tblTransactionPayments.TrnPayBillNo)
INNER JOIN tblPaymentMethods ON tblPaymentMethods.PayNo = tblTransactionPayments.TrnPayPayMethod
INNER JOIN tblTransactionMembers ON tblTillTransactionHeader.TTrnHdrTranNo = tblTransactionMembers.TrnMemHdrNo
INNER JOIN tblTillTransactionDetail ON tblTillTransactionHeader.TTrnHdrTranNo = tblTillTransactionDetail.TTrnDetHeaderNo
WHERE TTrnHdrTranNo ='CRX1'


Can anybody help me suss this out.
The error it returns in Access is Syntax Error (Missing Operator) in query expression

tblPaymentMethods.PayNo = tblTransactionPayments.TrnPayPayMethod
INNER JOIN tblTransactionMembers
ON tblTillTransactionHeader.TTrnHdrTranNo = tblTransactionMembers.TrnMemHdrNo
INNER JOIN tblTillTransactionDetail
ON tblTillTransactionHeader.TTrnHdrTranNo = tblTillTransactionDetail.TTrnDetHeaderNo
WHERE TTrnHdrTranNo ='CRX1'

Thanks