How do I make a "summary" query?

T

Tom K

I am trying to convert some of my Excel programs over to Access, since the
"core" data is maintained in Access. We have 2 production lines and make
several products across 2 shifts. I want to make a chart of the efficiency
(widgets/man-hour) for a particular product and shift each day. The raw data
tracks how much is made by line, by shift, by day. My problem is I want a
single total for both lines if they run a particular product on a specific
date. Once I have the totals, I can make some calculations in a query and
make the charts I want. (If I don't "summarize" data for each day and shift,
then Access "sums, averages, count, etc..." when I try to chart it.) I can't
figure out how to do it, what am I missing?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top