Help - Totals

[vicsalt]

Im running a query to some me total parts made between 2 dates. The dates are selected from a form with the query looking to this form to selected the date range.

When I run the query it shows me total parts made for each day. What i would like is a single total of parts between the range

I assum i could achive this by a 2nd query

 

[namliam]

You have the Date column as "Group by", change this to "Where" and you should get your desired result.

 

[vicsalt]

Thankyou - great