Balance <> 0

  • Thread starter Thread starter Terry
  • Start date Start date
T

Terry

This works fine for finding the balance of my GL account but I want the
records that are out of balance. When I put <> 0 into the criteria of
curBalance it promps for curDebitTot instead of running the SQL.



SELECT tblGL.strBatch, tblGL.dtmDate, Sum(tblGL.curCredit) AS curCreditTot,
Sum(tblGL.curDebit) AS curDebitTot,
CS_RoundAmount2([curDebitTot]-[curCreditTot]) AS curBalance
FROM tblGL
GROUP BY tblGL.strBatch, tblGL.dtmDate
ORDER BY tblGL.dtmDate;

Want to add something like this

Where [curBalance] <> 0
 
Terry,

Try it like this...
SELECT tblGL.strBatch, tblGL.dtmDate, Sum(tblGL.curCredit) AS
curCreditTot, Sum(tblGL.curDebit) AS curDebitTot,
CS_RoundAmount2(Sum(tblGL.curDebit)-Sum(tblGL.curCredit)) AS curBalance
FROM tblGL
GROUP BY tblGL.strBatch, tblGL.dtmDate
ORDER BY tblGL.dtmDate
 
Back
Top