Calculating weeks

  • Thread starter Thread starter Alex Hammerstein
  • Start date Start date
A

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
 
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
 
Back
Top