I just don't understand access sql, it is much different from mssql or mysql. This should be straight forward, but it doesn't work:
SELECT map.code, Sum([Debit Amount]-[Credit Amount])
FROM map left join data on map.code=data.code
GROUP BY map.code
HAVING map.code="600.03" and month([Trx...