replicating records according to the number of days

[Guest]

I have a simple table at the moment that records the date and time, e.g.
01/08/2005 13:33:00 for a particular person.

Here is the table schema:

ID :: Autonumber, 4
Event_Name :: Text, Joe Bloggs
Date :: Date/Time, 08/09/2005 01:00
EndDate :: Date/Time
Location :: Text
Description :: Memo, I will be on holiday
Category :: Text, Holiday
noofdays :: 5

I have a record for each event that occurs. What I need to do is to create
a query that replacates the record x number of times depending on the number
of days selected. For instance, if I select 5 in my table as the noofdays,
then I will have in my Query x5 records that are identical to the one above
corresponding to the days 09/09/2005, 10/09/2005 etc.... for 5 days.

Please help!

skc

 

[Arvin Meyer [MVP]]

Have a look at the following function:

http://www.datastrat.com/Code/GetBusinessDay.txt

Using that to calculate the final day. You do not need to store any of the
days if you can do the calculation.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access