Date Add Question

[PMK]

I run several teams that conduct works on monday to friday. Sometimes the
job takes one day, sometimes longer.

What I require is some "Date Addition" coding that will allow me to
automatically (from an initial start date) add each consecutive date to my
database based on the number of days I estimate the job to take. Saturdays
and sunday are excluded. I require this facility as I produce a form each
day (that contains all the new jobs for that day and jobs that are currently
ongoing)

To clarify:-

One job begins Monday 7th February 2005 and lasts for 4 days. I want to,
without having to type into my database the job reference number for the job
plus 08/02/2005, then 09/02/2005 and finally 10/02/2005 for each of the days.

So basically all i want is to add the start date of a job and the number of
days that the job will take and then have some coding that will allow for the
additional dates to be entered into the same table/query without me having to
do it all manually.

Apologies if I have been unclear or if I am asking a question that has been
answered elsewhere.

Thanking you all, as always, in anticipation

PMK

 

[PMK]

I would like to have a recod for each day

i.e

Job 0001 07/02/2005 over 4 days is my starting condition.

What I wish to see in my table/query is (after application of the
approrpiate coding)

Job 0001 07/02/2005
Job 0002 08/02/2005
Job 0003 09/02/2005
Job 0004 10/02/2005

As a further thought would it be possible to reduce the number by one for
each day
i.e.

Job 0001 07/02/2005 4 days
Job 0002 08/02/2005 3 days
Job 0003 09/02/2005 2 days
Job 0004 10/02/2005 1 days

Again, thanking you all in anticipation

PMK

 

[PMK]

Apologies

All job numbers should be Job 0001

Job 0001 07/02/2005 4 days
Job 0001 08/02/2005 3 days
Job 0001 09/02/2005 2 days
Job 0001 10/02/2005 1 days


Regards PMK