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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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