Rolling over database to next year

[alblonde89]

Hello!

I am trying to correct a problem I ran into last year. I work off of a database that was built by someone else so I have found lots of "Easter Eggs" over the last year and I'm not the most proficient Access user on the planet.
Last year, my database would not "roll over" to 2015 and display any reports for the week of December 29-January 2. It worked fine the following week. I think the issue is probably within the DatePart function, but I'm not 100% sure.
I use the database for scheduling and for this week's and next week's schedules, I am showing a week number of 51 and 52, respectively. Is there a way to increase the week number to 53, or do I need to rewrite the coding to begin the year on the week with January 4 as being the first "week of the year?" I believe there are ways to do both, but I honestly don't know how to fit them into my current coding.



I am not by any means great at any of this, so an elementary response would be very much appreciated!

[ItsMe]

The only way to answer your question regarding how to fix it, one would have to understand how the reporting is accomplished and the structure of the tables/data. To answer your question regarding rewriting the coding, it seems almost certain you will have to rewrite some code. Also, how the data is stored may be part of the issue.

[June7]

DatePart("ww", #12/29/2014#)

returns 53.

DatePart("ww", #1/2/2015#)

returns 1.

So as ItsMe said, we would need to know a lot more about your db structure and report design and exactly how the 'week number' is calculated. If you want a week to include days from different years (a 'crossover' week), this will not be accomplished with the DatePart function. One approach is to calculate the first date of the week that a given date falls into and use that 'first day of week' as the grouping criteria.

If you want to provide db for analysis, follow instructions at bottom of my post.

[alblonde89]

Thank you both so much for your quick replies. I will attach it as soon as possible this evening as I cannot do that at my current workstation. Looking forward to the assistance!