Code:SELECT TDate, Description, Credit, SUM(Credit) FROM tblRegister WHERE (TDate)>=#1/1/2021# And (TDate<=#12/31/2021#) GROUP BY Description ORDER BY Description;
Each record in tblRegister contain Description, TDate and Credit fields. I'm just tying to get totals relating to each Description in the table.
Not being at all familiar with this type of query, I don't understand what the error message is trying to teach?