I am byuilding this database which (among others things) will have to
produce a kind of calendar.
Users give in the appointments they have and how long they take.
F.e: John Doe is attending a conference which will take three days. This
conference starts on 12-07-2004
So the user would give in
a) Name John Doe (selectable from a list,
already done that)
b) Kind of appointment Conference (selectable from a list, already
done that)
c) Startdate 12-07-2004 Date/Time field
d) Howlong 3 Numeric field
Now it is very simple to calculate the Enddate(Startdate+HowLong-1)
I know how to convince Access2K to fill in an Excelsheet That John Doe is
attending a conference starting 12-07-2004. I can also see that very clearly
and easily in the Excelsheet I produce. But I need it to fill it in also for
the days 13-07 and 14-07. In fact, it needs to fill in all the dates
starting with the Startdate, ending with the enddate.
How do I do this? I am pretty worthless if it comes up to code so I would
prefer it to be done in a query of some sort but, to be honest, I am pretty
desperate now so I would even be prepared to hammer it in as they did in the
Stone-age :-p as long as I find a solution for this problem!
I sincerely hope that someone can help me!
TIA,
Henro