Access Report ???

I have a report that counts different fields.  Its updated as new records are added.  I need a report that looks like this:
As of Date                 Total Records in Process      BD        PP        PD        AR
12/13/11 4:00 PM               177                                177      107       143       35
12/14/11 4:00 PM               187                                187       107      143       45
12/15/11 4:00 PM               201                                 201      107       143       63

and so on...At the end of each day is fills in the numbers for that day.  We are trying to see how much output were doing a day.  I hope this gives you an idea what Im looking for

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dale FyeOwner, Developing Solutions LLCCommented:
It would help if we knew what your data looked like.
Jeffrey CoachmanMIS LiasonCommented:
And please post a sample of the *exact* output you are expecting.

It is not clear what you mean, because you "Total" looks like it only includes BD...?

If you want the total for all 4 fields, you can do that in a query then create a report from that.

Something roughly like this:

SELECT AsOfDate,BD,PP,PD,AR,NZ(BD)+NZ(PP)+NZ(PD)+NZ(AR) AS TotalRecordsInProcess

Then use the report wizard to create a simple report.

You can then insert a textbox in the report footer to total all the totals:
set the controlsource of the textbox to something like this:

You can sum all the fields using more textboxes and the same syntax...
jpb12345Author Commented:
that is the output Im expecting a whole table of days with totals for each column so I can compare day to day.  Here is what im doing:  there are 5 totals.  The first one is how many parts are in process, and the other four are different processes.  For example, there are 201 parts and so far all the parts got through BD, 107 through PP, and so on.  hope that helps
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

Jeffrey CoachmanMIS LiasonCommented:
Then give my suggestion a try and report back I stated you can total all of the individual columns with textboxes that have a controlsource of

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jpb12345Author Commented:
I have a report that does this already but the only thing is I wanted it to store the results of this query at the end of each day.  Unless I print my report everyday there is no way to see our productivity day to day.  The report I have works great to tell me where we are at.  I just was wondering if there was a way to make a summary report that at 4:00 PM everyday it will store the results and log them onto a report.  Does that make any sense?
Jeffrey CoachmanMIS LiasonCommented:
Can you please post a sample of this database/report.
I am having difficulty envisioning exactly what you are asking for, and why you need to "store" a value that can be calculated.

Sample database notes:
1. Back up your database(s).
2. Combine the front and back ends into one database file.
3. Remove any startup options, unless they are relevant to the issue.
4. Remove any records unless they are relevant to the issue.
5. Delete any objects that do not relate directly to the issue.
6. Remove any references to any "linked" files (files outside of the database, Images, OLE Files, ...etc)
7. Remove any references to any third party Active-x Controls (unless they are relevant to the issue)
8. Remove, obfuscate, encrypt, or otherwise disguise, any sensitive data.
9. Compile the code. (From the VBA code window, click: Debug-->Compile)
10. Run the compact/Repair utility.
11. Remove any Passwords and/or security.
12. If a form is involved in the issue, set the Modal and Popup properties to: No
    (Again, unless these properties are associated with the issue)
13. Post the explicit steps to replicate the issue.
14. Test the database before posting.

In other words, a database that we can easily open and immediately see and/or troubleshoot the issue.
And if applicable, also include a clear graphical representation of the *Exact* results you are expecting, based on the sample data.

jpb12345Author Commented:
you might not have to store it.   I guess the way it would work is to know what time certain fields were either checked off or not.  It would have to keep track of data entry time for this to work then after that we can do a query based on the data and when it was entered.
Jeffrey CoachmanMIS LiasonCommented:
...and the sample db...?
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.