G
Guest
I am aware how to format the date to show the week number in a query in
Access. However, my problem is for dates in January 2005. It is showing as
Week #2 for January 2nd etc when in fact it should be week 1.
Anyone have any ideas on how to get around this 'bug'? I will then be using
this query to extract information in Frontpage 2003. We have Access 2002.
I have tried to search everywhere... but to no avail as to how to rectify
this.
The user needs to be able to choose a week number in a give year and either
show all employees who worked on the project in a given week or one employee
at a time all their work for that week number. They basically type into a
timesheet what they have done for the day and their timecards are by week
number and projects are assigned as week number increments.
Thank you in advance.
Access. However, my problem is for dates in January 2005. It is showing as
Week #2 for January 2nd etc when in fact it should be week 1.
Anyone have any ideas on how to get around this 'bug'? I will then be using
this query to extract information in Frontpage 2003. We have Access 2002.
I have tried to search everywhere... but to no avail as to how to rectify
this.
The user needs to be able to choose a week number in a give year and either
show all employees who worked on the project in a given week or one employee
at a time all their work for that week number. They basically type into a
timesheet what they have done for the day and their timecards are by week
number and projects are assigned as week number increments.
Thank you in advance.