Re: count weeks automatically

Tech-Archive recommends: Fix windows errors by optimizing your registry

You need to define what you meant by No of Weeks in this case.

April has 30 days which is 4 weeks + 2/7 weeks.

--
HTH
Van T. Dinh
MVP (Access)


"Songoku" <Songoku@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:02C4EC15-B378-4465-B5C3-845C1CF64390@xxxxxxxxxxxxxxxx
> Hi,
>
> I am using access 97 and I have tables which have dates in the following
> format mmm/yyyy. I was just curious to find out if there is a way to work
out
> the number of weeks based on the above mentioned date format?
>
> so output similar to the followin would be a bonus........
>
> DATE No Of Weeks
> APR 2002 4
>
> Thanks


.

Relevant Pages