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?
"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?