Wonder if I can get some help with this?

I have a database that consists of employees, a week ending date, hours worked on a particular job, and a job number.

What I am trying to do, is when I do a find for a particular person, it will give me the hours worked by employee. How can I add on, the grand total number of hours from everyone, on this particular job? What I am trying to show, is their total hours, and the total hours of the job by everyone. This will enable me to get the % of their hours worked. Right now, the best I can get is it just totaling up for that particular employee only, not the total for the entire job.

I can't seem to get the grand total of all the hours, complete for the job.

Any help is certainly appreciated, thanks!

I am not sure I follow this fully - it seems a report sub-summarized by job and employee should produce what you want, i.e:

Job A:

• Adam ... 5 hours

• Betty ... 3 hours

• Cecil ... 4 hours

Total of Job A: 12 hours

Job B:

• Adam ... 3 hours

• David ... 6 hours

Total of Job B: 9 hours

Thanks for the response :, maybe I can make this a bit clearer? I have many employees, that work on particular jobs, that last for months. What I am looking to do, is (which I can now..) is do a find on one person, to total their hours put to this job. What I need to add to this report is also a total of everyone's hours also put to this job, a grand total, showing the total hours for all. (i.e. Tom has 56 hours, and total for all is 356 hours. I can do either or, but not both together. Thats what I am trying to figure out. Sort of like a mixed search on the same report. This is what I am not sure is possible? ok, maybe, but it's beyond me.

Many thanks!

It is possible to do it the way you describe, if you "steal" the total for a job from the related job record. But it would be much simpler if you produced the report for all employees at the same time.

Seems like just a standard summary field is required. Is there some reason that doesn't work? You do know how to do summary field and standard sub-summary reports?

Thanks for the help, yes I already have a standard summary field, it's working just fine. The the issue is, to add another summary field that contains the total from everyone that worked on it, assuming I just did the search for one person, or a group. I think I am going to try the previous post of stealing it from another field setup that will have it, and see if I can get that to work. But... thank you both for the suggestions! I certainly appreciate it!

Thanks Again!

No, you do not have to add another field.

You have to add another PART.

Just put the summary field in the trailing grand summary part.

Like I said, this is just basic FileMaker summary reporting.

the issue is, to add another summary field that contains the total from everyone that worked on it, assuming I just did the search for one person, or a group.

If you did a search for one person, or a group, then a summary field placed in a trailing grand summary part will show the total for that person/group.

Resolved this by adding another layout with a field containing the grand totals of all, then doing a lookup of these totals to add to the report I was trying to do. Basically, when doing a find of a few members, the summary and parts only adds up those finds in the totals, but wanting to do a comparison to those found as a percentage to the whole, I took the 'whole' amount and did a lookup to bring that in. Worked out okay in the end. Thanks to all for the responses and help, much appreciated!