Hi guys, 

I been working on this possibly easy task for several days now and really I'm past my Google up Filemaker skills.

I have developed time-sheet which is using job codes do differ between jobs and boss wants me to add feature which would count total time for those separate jobs. Sometimes there might be few records with same job "number" and other time is just one.

I have exported all jobs into one record with times and codes but now need to add same record names into one record with total time. Example ab 2, ab 3 into ab 5. Job names are random, generated by boss.

I have attached simple file set up as the part I'm working on.

 

Any geeks out there ??

Please help 

export sorted.zip

boss wants me to add feature which would count total time for those separate jobs.

 

 

Use a summary field defined as Total of [YourTimefield]. Sort the records by JobID and show them in a list layout, having a sub-summary [when sorted by JobID] part. Place the summary field in this part. Note that you can remove the body part to make this a summary-only report. No exports or other "tricks" are required here - this is a basic built-in functionality of Filemaker.

 

 

---

P.S. I'll show you geeks.

Use a summary field defined as Total of [YourTimefield]. Sort the records by JobID and show them in a list layout, having a sub-summary [when sorted by JobID] part. Place the summary field in this part. Note that you can remove the body part to make this a summary-only report. No exports or other "tricks" are required here - this is a basic built-in functionality of Filemaker.

 

 

---

P.S. I'll show you geeks.

Thank you, you did show me