barendrecht82
Gebruiker
- Lid geworden
- 24 mrt 2013
- Berichten
- 230
Wat doe ik fout?
Code:
SELECT Val([reknr]) AS Rekeningnr, dbo_grtbk.oms25_0, dbo_GeneralLedgerBalances.GeneralLedger, dbo_GeneralLedgerBalances.AmountDC, Year([Reportingdate]) AS Expr1, Val([Journal]) AS Expr2
FROM dbo_grtbk LEFT JOIN dbo_GeneralLedgerBalances ON dbo_grtbk.reknr = dbo_GeneralLedgerBalances.GeneralLedger
GROUP BY Val([reknr]), dbo_grtbk.oms25_0, dbo_GeneralLedgerBalances.GeneralLedger, dbo_GeneralLedgerBalances.AmountDC, Year([Reportingdate]), Val([Journal])
HAVING (((Val([reknr]))>=80023500) AND ((Year([Reportingdate])) Like "2015") AND ((Val([Journal]))<>"90"));