Calculating weeks

[Alex Hammerstein]

Hi I have a number of student records all of which have a start date and a
leaving date, which can be any time.

Based on students who were current on the course as at 01/04/08 I need to
calculate the total number of students weeks worked between 1/4/08 and
31/3/09.

I have no real idea how to do this. I was going to create a query that
calculated the elapsed days between 1/4/08 and any date left, then divide
that by 7.

However I am not sure How I would then get the whole total totgether.

Any help much appreciated

Alex

 

[Beetle]

Look at the DateDiff function in Access help.
The interval argument "ww" will return the number
of weeks. Syntax looks like;

DateDiff("ww", [Date1], [Date2])

_________

Sean Bailey