records to a table. Each record of this table has a unique autonumber
ID, then has a date. I am trying to add 1 month of dates from the last
date listed in the table (Example: if the last date in the table is Jan
31, 2004 then it will need to add a record for each date between Feb 1,
2004 and Feb 29, 2004). There is also another table which has a record
to correspond to each record of the dates table that is tied by the
intDateID (previously mentioned autonumbered key), so I will need to add
the necessary records here as well.
My big question is, how would I write my loop for inserting these date
sequential records? I don't want to just add 30 days because each month
doesn't have 30 days. Any help is greatly appreciated.
Cutter
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
