access sql groups

  1. O

    help with query

    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...

Some videos you may like

This Week's Hot Topics