Help.. (1 Viewer)

[mugman17]

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.

 

[llkhoutx]

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.