Making report for tracking production

[winniepoohbear38501]

Hello all,
I have been using excel spreadsheet that makes my head spin after looking at it for 3 seconds, that has lookup tables and many sheets and more lookup tables to pull information from one page to another. I am trying to build a database to get rid of some of the confusion and room for error.

I have built the new database and I'm having trouble figuring out how to pull everything out the way I want for the reports. I am needing to do a monthly average, some daily/monthly totals and a running total for each month. the first part I'm having trouble with is displaying the month on a separate page from the other month's in my report. I have figured out how to summarize the dates with two totals next to them, but I want to add those two totals together on each day for a grand total amount, don't know how to summarize the data in the query correctly

I'll see if I get reply's and see what my response I get is and post for more help as I figure out what I am actually needing. (I have a tendency to over complicate all things I do in access).

Thanks in advance

[llkhoutx]

I just answered this question for another poster. Search this forum for "LLKHOUTX" and today's date to find that post.