Jump to content
Sign in to follow this  
AnthonyDixon

Calculate totals from previous years

Recommended Posts

I have an employee table with an employee leave child table which contains a date field and an hours taken field. My employee table contains a field that determines the allotted hours allowed to be taken each year. I am currently calculating the total time taken for the current year and displaying the remaining balance left for the year. What I'm trying to calculate is the balance of time not taken for all previous years. I'm just not sure how to how to arrive at the time not taken totals for each year.

Thank you in advance for any help.

Tony

11 Advanced Mac/PC

Employee Leave.fp7.zip

Share this post


Link to post
Share on other sites

it seems that the number of hours allowed per year is specific to an employee - but doesn't it ever change from year to year?

Note also that your file doesn't tell us in which years an employee was employed; if John Doe doesn't have any leaves in 2009, it could be because he didn't take any (and in such case he has a balance of 40 hours), or because he started working in 2010 only.

Share this post


Link to post
Share on other sites

Yes, there will be a field for date of hire and the hours allowed per year may change from year to year. oh boy I guess now I have really complicated things.

Share this post


Link to post
Share on other sites

What a great approach! This changes everything for the better.

Thank you so much.

Tony

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.