I need to summarize how many hours a worker worked in one day. Workers are scheduled in a table called Schedule Line Items, which consists of Job Tickets (another table) for the Day. Worker Name a

I need to summarize how many hours a worker worked in one day.

Workers are scheduled in a table called Schedule Line Items, which consists of Job Tickets (another table) for the Day. Worker Name and Total Hours are chosen via pop-up in a repeating field in the Schedule Line Items table.

One worker may work several jobs during the day, and could appear in any repeat of the Worker Name field, with an associated total hrs worked on that job.

How can I summerize how many hours one worker worked in a day?

Edited September 17, 200718 yr by Guest