Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Vacation Database Question

Discussion in 'Information Technology' started by Julie, Jul 28, 2006.

  1. Julie

    Julie
    Expand Collapse
    Guest

    I am working on a vacation database and I need to calculate their vacation
    based on their anniversary. So, if they were hired on 12/1/93, they will be
    able to have 160 hrs available to use. Each person would be different based
    upon their anniversary date.
     
  2. Loading...

    Similar Threads Forum Date
    Confucianism Confucious on Summer Vacation Interfaith Dialogues Jul 18, 2011
    Leisure Meditation Vacations: Taking A Walk on the Mild Side Business, Lifestyle & Leisure Dec 8, 2009
    Rath Yatra - Vacation for the Gods in India (About.com) Interfaith Dialogues Jul 8, 2005
    USA NSA has massive database of Americans' phone calls (USA Today 5.11.2006) Breaking News Jun 11, 2013
    Some database errors while navigating SPN forums Announcements Dec 29, 2004

  3. Craig Hornish

    Craig Hornish
    Expand Collapse
    Guest

    Hi,
    You also have some business logic questions to answer.
    When do you calculate the vacation time?
    First of year?
    Then what do you do about someon hired in march of last year?
    Is it prorated?
    On anaversery date?
    Have to make sure that it is calculated at that time.
    And/or Do you accumulate vacation time prior to the aniversery date?
    After the first 6 months you get 20 hours to use for the rest of the
    (what time period)
    etc...

    I would use a table that defined the basics
    tblVacationHours
    Years HoursAvail
    1 40
    5 80
    10 120
    99 160

    Then depending on your buiness logic you need to calculate the
    difference (ie =DateDiff("yyyy",#12/1/1993#,Now()) - this rounds up to the
    next year - 13 years) and compare it to the table.


    --
    Craig Hornish

    Visit weekly Access conferences
    Tuesday, 11:00am-12:30pm (Eastern US)
    Thursday, 3:30pm- 5:00pm (Eastern US)

    http://community.compuserve.com/n/pfx/forum.aspx?webtag=ws-msdevapps

    "Think outside the box, because anything is possible."
    "How long it will take or whether it requires divine intervention is another
    issue"

    "Julie" <Julie@discussions.microsoft.com> wrote in message
    news:1B368936-FA17-4223-8276-4D79D1CC895E@microsoft.com...
    >I am working on a vacation database and I need to calculate their vacation
    > based on their anniversary. So, if they were hired on 12/1/93, they will
    > be
    > able to have 160 hrs available to use. Each person would be different
    > based
    > upon their anniversary date.
    >
     
  4. Roger Carlson

    Roger Carlson
    Expand Collapse
    Guest

    On my website (www.rogersaccesslibrary.com), is a small Access database
    sample called "VacationUsed.mdb" which might give you an idea.

    --
    --Roger Carlson
    MS Access MVP
    Access Database Samples: www.rogersaccesslibrary.com
    Want answers to your Access questions in your Email?
    Free subscription:
    http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L


    "Julie" <Julie@discussions.microsoft.com> wrote in message
    news:1B368936-FA17-4223-8276-4D79D1CC895E@microsoft.com...
    > I am working on a vacation database and I need to calculate their vacation
    > based on their anniversary. So, if they were hired on 12/1/93, they will

    be
    > able to have 160 hrs available to use. Each person would be different

    based
    > upon their anniversary date.
    >
     
  5. Julie

    Julie
    Expand Collapse
    Guest

    What I need to figure out now is how to get a query to look at their
    anniversary date and add in what amount they get awarded. When a new employee
    is eligible for vacation is on their anniversary date and then they can start
    taking it. So, if someone starts in march they have to wait until the
    following march to use their vacation.
    "Craig Hornish" wrote:

    > Hi,
    > You also have some business logic questions to answer.
    > When do you calculate the vacation time?
    > First of year?
    > Then what do you do about someon hired in march of last year?
    > Is it prorated?
    > On anaversery date?
    > Have to make sure that it is calculated at that time.
    > And/or Do you accumulate vacation time prior to the aniversery date?
    > After the first 6 months you get 20 hours to use for the rest of the
    > (what time period)
    > etc...
    >
    > I would use a table that defined the basics
    > tblVacationHours
    > Years HoursAvail
    > 1 40
    > 5 80
    > 10 120
    > 99 160
    >
    > Then depending on your buiness logic you need to calculate the
    > difference (ie =DateDiff("yyyy",#12/1/1993#,Now()) - this rounds up to the
    > next year - 13 years) and compare it to the table.
    >
    >
    > --
    > Craig Hornish
    >
    > Visit weekly Access conferences
    > Tuesday, 11:00am-12:30pm (Eastern US)
    > Thursday, 3:30pm- 5:00pm (Eastern US)
    >
    > http://community.compuserve.com/n/pfx/forum.aspx?webtag=ws-msdevapps
    >
    > "Think outside the box, because anything is possible."
    > "How long it will take or whether it requires divine intervention is another
    > issue"
    >
    > "Julie" <Julie@discussions.microsoft.com> wrote in message
    > news:1B368936-FA17-4223-8276-4D79D1CC895E@microsoft.com...
    > >I am working on a vacation database and I need to calculate their vacation
    > > based on their anniversary. So, if they were hired on 12/1/93, they will
    > > be
    > > able to have 160 hrs available to use. Each person would be different
    > > based
    > > upon their anniversary date.
    > >

    >
    >
    >
     

Share This Page