Hi,
I have the below query in Access and it seems I am getting a line for each line in the tables. I only want a sum for the entire table which in return would give me one line back. Can anyone help? I have tried different variations in the group by section.
SELECT SUM(A.QUANTITY) AS...