In excel its a simple formula of =NETWORKDAYS(A1,B1) and there is the answer.
How in my query can I work out the working days difference between job visit and job completion. Also in excel its easy to group a set of results together, how can I say if the days difference is between 0&7 then 1 Week, between 8&14 then 2 Week, between 15&21 then 3 Week and if anymore then 4 Weeks or More?
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.