syntax error in query

[Mike Hughes]

I have this query that I'm trying to convert from SQL to be used in Access, but the first problem that I ran into was a syntax error message (I have attached). It appear there may be several problems here, but this is the first I have run into...I'm sure more will follow. Please give it a look and advise if you have the time. Thanks!

SELECT
COUNT (B.CASE_ID),
SUM (A.AMT_TO_DISTRIBUTE) AS [HELD AMOUNT],
NOLDBA_INT_CASE_STATUS.IV_D_DO_CODE,
NOLDBA_RECEIPT.CD_REASON_STATUS

FROM NOLDBA_INT_CASE_STATUS B INNER JOIN NOLDBA_RECEIPT A ON B.CASE_ID =A.ID_CASE

WHERE (((A.CD_STATUS_RECEIPT)="H") AND ((A.DT_DISTRIBUTE)=#1/1/2001#) AND ((A.DT_END_VALIDITY)=#12/31/9999#))

AND NOT EXISTS (SELECT 1 FROM NOLDBA_RECEIPT K
WHERE A.DT_BATCH = K.DT_BATCH
AND A.NO_BATCH=K.NO_BATCH
AND A CD_SOURCE_BATCH = K. CD_SOURCE_BATCH
AND A.SEQ_RECEIPT = K.SEQ_RECEIPT
AND K.IND_BACKOUT = 'Y'
AND K.DT_END_VALIDITY = #12/31/9999#)

AND ((TRIM(A.ID_CASE) IS NOT NULL
AND A.ID_CASE = B.CASE_ID)
OR
(TRIM (A.ID_CASE) IS NULL
AND B.CASE_ID = (SELECT MIN(Y.CASE_ID) FROM
NOLDBA_INT_CASE_STATUS, NOLDBA.INT_CASE_MEMBER
WHERE A.ID_PAYOR = Z.MEMBER_ID
AND Z.RELATION_CODE IN ('A', 'P')
AND Z.CASE_ID = Y.CASE_ID)))

GROUP BY IV_D_DO_CODE,
CD_REASON_STATUS
ORDER BY IV_D_DO_CODE;

 

[a.sinatra]

SELECT 
COUNT(B.CASE_ID), 
SUM(A.AMT_TO_DISTRIBUTE) AS [HELD AMOUNT], 
[NOLDBA_INT_CASE_STATUS.IV_D_DO_CODE], 
[NOLDBA_RECEIPT.CD_REASON_STATUS]

FROM NOLDBA_INT_CASE_STATUS B INNER JOIN NOLDBA_RECEIPT A ON B.CASE_ID = A.ID_CASE

WHERE (([A.CD_STATUS_RECEIPT] = "H") AND ([A.DT_DISTRIBUTE ]= #1/1/2001#) AND ([A.DT_END_VALIDITY] = #12/31/9999#))

AND NOT EXISTS (SELECT 1 FROM NOLDBA_RECEIPT K
WHERE [A.DT_BATCH] = [K.DT_BATCH]
AND [A.NO_BATCH] = [K.NO_BATCH]
AND [A CD_SOURCE_BATCH] = [K.CD_SOURCE_BATCH]
AND [A.SEQ_RECEIPT] = [K.SEQ_RECEIPT]
AND [K.IND_BACKOUT] = 'Y'
AND [K.DT_END_VALIDITY] = #12/31/9999#)

AND ((TRIM(A.ID_CASE) IS NOT NULL
AND A.ID_CASE = B.CASE_ID)
OR 
(TRIM (A.ID_CASE) IS NULL
AND B.CASE_ID = (SELECT MIN(Y.CASE_ID) FROM 
NOLDBA_INT_CASE_STATUS, NOLDBA.INT_CASE_MEMBER
WHERE [A.ID_PAYOR] = [Z.MEMBER_ID]
AND [Z.RELATION_CODE] IN ('A', 'P')
AND [Z.CASE_ID] = [Y.CASE_ID])))

GROUP BY IV_D_DO_CODE,
CD_REASON_STATUS
ORDER BY IV_D_DO_CODE;

Try that
________
Chrysler Sebring (Coupe)