It's not funny anymore. I have a projects database that tracks our publishing projects including hours charged to specific jobs. Hours, employee, position and date are recorded in a single line item that is separate table. What I need it to filter the line items by job, employee, position and dates. Meaning total hours for a job, total editing, design, how many hours were spent in March, how many hours has Joe spent on the job, etc. My solution was to create table instances for each position then use global fields "editor" and a calculation to add hours in the new table occurence. Can someone describe a simpler way? thanks

If the result is supposed to be printed anyway, try a sub-summary report instead.

the sumarized data - i.e. cumulative hours of editing, designing for each job are posted on the layout of each Project record. Therefore a summary is not possible. In the project table are calculation fields summarizing data from the time line item table. Is that a problem? or should the calculations be made in the same table the data can be found?