Jump to content
Sign in to follow this  
klj

Can't find easy button

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.