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.
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.