Query to sum sales for agent between two dates

[JackBauer]

Hi there,

I have data table of this info:

Date Name QuantitySold
2017-10-10 John 50
2017-10-11 James 50
2017-10-11 John 50

How to run a query which will show me a total for quantity sold between two dates:

Between 2017-10-10 and 2017-10-11

John 100
James 50

[ranman256]

Make a form, put a combo box to pick agent
put in 2 text boxes: txtStartDate, txtEndDate

then the query will look at these controls:

Please Login or Register  to view this content.

put a button to open the query:

Please Login or Register  to view this content.

to show ALL agents:

Please Login or Register  to view this content.