Cant get this query figured out (1 Viewer)

[Windsor302]

I have 6", 36" and 42" pipe that is welded together. I want to show the total of welds completed per size between certain dates. I have a query that seperates it out by individual date but i just want a total between a range of dates. Thanks.

 

[cookiegary01]

If you want to keep the query you have, then make a copy, else use it to do this:
In the criteria row of the date type this: Between [Please Enter date1] AND [Please Enter date2]
Now run the query, enter date1 click OK, then enter date2 and click OK.
You now have the results within 2 dates.

Now to get the totals per dimension/pipe, do this:
Make a new query and use the previous query as a source click the Totals button.
Then group by Dimension and count or sum the welds (date can be excluded).

 

[Windsor302]

wont that show the total of all and not individual sizes? unless im doing something wrong. Thanks

 

[cookiegary01]

No. In the Totals Query, You GROUP BY Individual sizes and Total (or count) the sizes.
It will give you a total or count per group/size