klj Posted April 23, 2007 Posted April 23, 2007 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
Ender Posted April 23, 2007 Posted April 23, 2007 If the result is supposed to be printed anyway, try a sub-summary report instead.
klj Posted April 24, 2007 Author Posted April 24, 2007 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?
Recommended Posts
This topic is 6484 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now