Date Add Question

[Guest]

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

 

[Joseph Meehan]

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

Do you want to have a record for each day, or a start and end date in
each record or ???

 

[Guest]

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

 

[Guest]

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

 

[Joseph Meehan]

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

That does make it clear to me what you want. I am going to beg off of
offering a suggestion other than I do believe it can be done and I don't
believe it is going to take much effort, but if I were to suggest the code
needed, it would take me into a couple of areas I have not needed to work in
so it would take me a lot of time to get it right. Right now I just don't
have that much time. Sorry.

I know there are others who frequent this group who can handle this and
hopefully one will offer their help. It should only take a few lines of VBA
to do the job.

I suggest giving it until Tuesday and if no reply try reposting the
question making it clear that you want a new record for each expected new
day and the format you would like as you have done for me.

Good Luck.