Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2009
    Posts
    15

    timesheet database with weekly ID's

    Hi there
    I'm new to the database field and i am trying to setup a timesheet database for our company, the old one is very painful so i'm trying to update it.

    our timesheets run from wednesday to wednesday and for each week in the month we use the following code - Aug09-1 = week 1, Aug09-2 = week2 etc.
    i am trying to figure out a formula that will generate this automatically for me using the current date and would create a new code each week ready to be used. the figure would be stored in the database so it can be used in reports, billing and employee payments.
    currently the guys in the workshop have to manually put enter this in and they often get it wrong.
    i hope i have supplied enough info.
    cheers
    Aaron

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    what do you call the week that runs from wed sept 30 to tues oct 6 ?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Sep 2009
    Posts
    15
    this would be Sep09-5
    it is determined by when it starts - week starting wednesday dd/mm/yy

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    so all you want is to generate the week codes?

    which database system are you using?

    let me guess... ms access
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Sep 2009
    Posts
    15
    You Guessed Right i'm using MS Access 2007.
    yeah i would like to generate my week codes automatically if possible. i thought it might be a simple thing but if its a misson then its not worth it and i will manually enter these dates for the techs to select.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •