SELECT TblCharges.Chargeamt, TblCharges.Chargedate, TblPayments.Creditamt, TblPayments.Recdate
FROM TblPayments, TblCharges;
Trying to get totals (Chargeamt) and (Creditamt) by month (and ultimately by year)
The Chargeamt and Recdate date formats are day/month/year
I'm missing something I'm sure is simple.
FROM TblPayments, TblCharges;
Trying to get totals (Chargeamt) and (Creditamt) by month (and ultimately by year)
The Chargeamt and Recdate date formats are day/month/year
I'm missing something I'm sure is simple.