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.
marlind605Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

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

marlind605Author Commented:
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
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.
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
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
0
Determine the Perfect Price for Your IT Services

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

marlind605Author Commented:
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.
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
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.
0
marlind605Author Commented:
Thanks Boyd. I will work on a excel for you.
0
marlind605Author Commented:
The spreadsheet shows the totals and where they came from. I also will attach new db.
Time-By-Organization.xls
OrganizationTotal.accdb
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
Great. I will take a look
0
marlind605Author Commented:
Anyone have any answers for me on this problem?
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
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.
0
marlind605Author Commented:
0

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
marlind605Author Commented:
Had a lot of trouble but this seems to have solved the problem.
0
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.