count weeks automatically

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



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
.