Not very good with queries.

I have a query that has 5 fields. Transaction Date, Quantity, Price, etc.

I want to create a query where it sums the total quantity of all deals by transaction date. Right now, I am getting the same date popping up several times.

Include only the date field and the field that you was to sum in your query, otherwise you'll get a record for each unique field in a column.