jpb12345
asked on
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
thanks
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
thanks
Dale Fye
It would help if we knew what your data looked like.
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
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:
=Sum(TotalRecordsInProcess
You can sum all the fields using more textboxes and the same syntax...
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
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:
=Sum(TotalRecordsInProcess
You can sum all the fields using more textboxes and the same syntax...
ASKER
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
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, ...post 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.
JeffCoachman
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, ...post 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.
JeffCoachman
ASKER
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.
...and the sample db...?