Welcome to SPN

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

Sign Up Now!

track used and accured vacation time for employees

Discussion in 'Information Technology' started by Pam, Nov 2, 2005.

  1. Pam

    Expand Collapse

    I want to track vacation time for employees - as they use it and as they earn
  2. Loading...

  3. Rick B

    Rick B
    Expand Collapse

    Ok. What do you need from us?

    We can't build a database for you. What have you done so far? What's
    stumping you?

    We need a specific question that we can answer in a paragraph or two.

    There are a lot of variables in this. Do you want the database to do
    something to accrue days, or will you add them? I have a table and form
    where I do this, but I go in and add my 20 days in the beginning of the year
    and then I add a new record with a negative number each time I take a day.
    My form pulls only details from the current year. I have a button that will
    show me the previous year and the next year. If I carry over days from the
    previous year, those would also be added as an entry to my table with a
    positive number.

    I only do this for me and my small team of about 6 people, so it is pretty
    easy to maintain. I include notes to indicate the reason (if any) for a
    day. I also add records for sick days, but I put the quantity as "0" so
    they are really just notes.

    Rick B

    "Pam" <Pam@discussions.microsoft.com> wrote in message
    >I want to track vacation time for employees - as they use it and as they
    > it

Share This Page