Access Report ???

jpb12345 used Ask the Experts™
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

Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Dale FyeOwner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010

It would help if we knew what your data looked like.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

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...


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
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

MIS Liason
Most Valuable Expert 2012
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


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 Liason
Most Valuable Expert 2012

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.



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 Liason
Most Valuable Expert 2012

...and the sample db...?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial