By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,663 Members | 1,813 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,663 IT Pros & Developers. It's quick & easy.

Need help with 52 week calendar

P: 14
Hello Forum,
I will try to be as detailed as possible, I feel you would better understand what I am trying to do if I could email or upload the database to you all instead. If there is a way to upload, could someone tell me how this is done?

What I have been working on is a database that will help schedule a maintenance departments personnel based on a 52 week calendar.

This is where I am stuck and was hoping someone could give me some direction or ideas. I have a table that stores all the information a technician would need to finish. Since there is just so much work to do, I am trying to schedule it one a weekly bases for the whole year.
Example: out of 5,000 assignments needing to get done I want to assign only 20 of them to each tech (6 of them) and tell Access to allow me to print out a report that only shows the first 20 things needing to get done and then not repeat itself until the next year and so on...
This would be created by the table capturing the techs names, assignments, the amount of time each assignment should take and the most important one is assigning it to a weekly, Bi-weekly, Monthly, etc... Schedule and having it show me the results when asked.

Any help would be appreciated
Jan 30 '08 #1
Share this Question
Share on Google+
3 Replies


P: 14
Anyone have any idea how to print a report on a certain week of the year? I am scheduling based on a 52 week calendar and would just need to know how to get access to understand that I want it to print a certain report only if that calendar week has been meet.

Any advice, thx in advance...
Jan 30 '08 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
Anyone have any idea how to print a report on a certain week of the year? I am scheduling based on a 52 week calendar and would just need to know how to get access to understand that I want it to print a certain report only if that calendar week has been meet.

Any advice, thx in advance...
You can use the DatePart() function to determine the week number. The syntax is ...

DatePart ( interval, date, [firstdayofweek], [firstweekofyear])

The following should return the week number of the current date.

DatePart ("ww", Now(), vbSunday, vbFirstFullWeek)
Feb 5 '08 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
Hello Forum,
I will try to be as detailed as possible, I feel you would better understand what I am trying to do if I could email or upload the database to you all instead. If there is a way to upload, could someone tell me how this is done?

What I have been working on is a database that will help schedule a maintenance departments personnel based on a 52 week calendar.

This is where I am stuck and was hoping someone could give me some direction or ideas. I have a table that stores all the information a technician would need to finish. Since there is just so much work to do, I am trying to schedule it one a weekly bases for the whole year.
Example: out of 5,000 assignments needing to get done I want to assign only 20 of them to each tech (6 of them) and tell Access to allow me to print out a report that only shows the first 20 things needing to get done and then not repeat itself until the next year and so on...
This would be created by the table capturing the techs names, assignments, the amount of time each assignment should take and the most important one is assigning it to a weekly, Bi-weekly, Monthly, etc... Schedule and having it show me the results when asked.

Any help would be appreciated
I am merging this with your previous question on this issue which I have replied to.
Feb 5 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.