Microsoft Access 2013 Request Header Total not coming up properly
I have a report Time By Organization. I need the total jobs to come up in the report. Each organization may have many time records for a job but I only want to show the number of jobs. In the attached example I have Rank Find has 1 job, trans flex has 27 and unitouch has 1. I had been creating a table with my totals and including that in the query but I think there must be a better way. Thanks for the help.
Use a totaling query to dynamically calculate the totals in place of the table.
The Best Practices Rule for data normalization it to not store any calculations (like totals) if they can be calculated.
The Best Practices Rule for data normalization it to not store any calculations (like totals) if they can be calculated.
Took a look at your report.
I simple move the totals to different group footer sections and change the control source of a few controls.
See is the attached is what you want.
OrganizationTotal-hitechcoach.accdb
I simple move the totals to different group footer sections and change the control source of a few controls.
See is the attached is what you want.
OrganizationTotal-hitechcoach.accdb
ASKER
I don't think that is quite right. Each organization has a total line at the top. The first one the total Jobs = 1 the second one Transflex the total jobs is 10. I want this total to show up on the organization header. There may be multiple time records for each job For some reason I have it counting all the records I just need to count the total distinct jobid's or jobs for each organization.
Unfortunately I know nothing about how you want your database to work. Without seeing an example of what you want the output, I am only able to guess about what you want.
It would be helpful to see a sample of what you want I to look like. Maybe create an example in excel with the correct totals.
It would be helpful to see a sample of what you want I to look like. Maybe create an example in excel with the correct totals.
ASKER
Thanks Boyd. I will work on a excel for you.
ASKER
The spreadsheet shows the totals and where they came from. I also will attach new db.
Time-By-Organization.xls
OrganizationTotal.accdb
Time-By-Organization.xls
OrganizationTotal.accdb
Great. I will take a look
ASKER
Anyone have any answers for me on this problem?
I had to be away for a few days. I am looking at it now ...
I am still confused. I don't now what you really want.
The spreadsheet has a column H that does not appear on the Access report. Is that what you are trying to add?
The Excel file you attached looks like you may have exported the Access report. It does not look anything like the Access report format.
What would be helpful is an Excel file that looks Exactly like how you want the report to look.
I am still confused. I don't now what you really want.
The spreadsheet has a column H that does not appear on the Access report. Is that what you are trying to add?
The Excel file you attached looks like you may have exported the Access report. It does not look anything like the Access report format.
What would be helpful is an Excel file that looks Exactly like how you want the report to look.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Had a lot of trouble but this seems to have solved the problem.
ASKER
OrganizationTotal.accdb