Multiple Charts from one Report/Query

[dcampoy1]

As a project for my night school I need to make a weekly production chart by department (7) for each of the 3 shifts showing average pieces per hour per day. Also, need to show total amount of pieces, screens, and average per hour for the week on the title.

I only have one Form with 12 fields, a query, and a table to work with.

need advice or where to find information,

thanks

[HansV]

Welcome to Eileen's Lounge!

Your question is rather broad, so I'll give a general answer.
You can create Totals queries to aggregate data. In a Totals query, you can group by some fields, and calculate the sum, average, minimum, etc. of other fields.
You can use such queries as record source for a report, or as row source for a chart, etc.

S0385.png

So I'd study up on Totals queries.

We'll be happy to assist you if you have more specific questions.

[dcampoy1]

Thanks....
I will look into that..
Dante