Try
SELECT
A.CUS_NUM_AR,
A.INS_CO_AR,
A.APPLY_TO_AR,
AT.AttributeID,
SUM(A.TOTALAMOUNT) AS 'Total Amount'
FROM AR700.dbo.tblAROPEN A
INNER JOIN LMSDATA.dbo.tblCustomerAttribute AT
ON (A.CUS_NUM_AR = AT.CustomerNumber AND AT.AttributeID = 3)
WHERE
A.INS_CO_AR IN ('0','000')
AND
A.TOTALAMOUNT >0
GROUP BY A.CUS_NUM_AR,A.INS_CO_AR,A.APPLY_TO_AR,AT.AttributeID
ORDER BY A.CUS_NUM_AR
I just added parenthesis on the JOIN, not that I think it will help
I'm fairly certain I wouldn't trust Access 97 for anything ...
Bug: Records disappear when you sort them[
^]
Best regards
Espen Harlinn