Report problem with converting standard calendar to 4-5-4 calendar.

  • Thread starter Thread starter telvox
  • Start date Start date
T

telvox

Hello,
I am creating a report for tracking data on a weekly base.
Everything in the report works fine and each week is displayed
correctly, except for the fact that the report needs to be in account
4-5-4 format so that it matches other data. Does anyone know the math
to convert the standard week that access uses into the week number on a
4-5-4 calendar? I'm trying to avoid hard coding dates into a table to
avoid extra matnaince that would bee needed.
 
The extra table (WeekNumber, StartDate, EndDate) might be the best way to
handle this in terms of accuracy (and maybe even in terms of speed).

Another method that would involve you accepting Access week number
calculation and using that would be something like the solution outlined
below.

I'm assuming that you have periods of the year defined on week numbers, so
week numbers
1,2,3,4 = period 1
5,6,7,8,9 = period 2
10,11,12,13 = period 3
etc.

The easiest way to do this might be a table with (one time table with 52
(53?) rows)
WeekNumber (1 to 53)
PeriodNumber (1 to12 or 1 to 13)

A math function would be more complex, but it could probably be done.
However, I think it would take a while to work out the exact math.
 
Back
Top