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?
 
marlind605Author Commented:
0
 
marlind605Author Commented:
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
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
 
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 MVPCommented:
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 MVPCommented:
Great. I will take a look
0
 
marlind605Author Commented:
Anyone have any answers for me on this problem?
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
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:
Had a lot of trouble but this seems to have solved the problem.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.