Adding sequential dates via an append query

[RickR]

Hello Everyone,

I'm trying to append a weekly set of records to a table. The current append query adds one record, the StartDate, which works outstanding (Many thanks to DavidR for the help on that).
Here is the SQL for that:

INSERT INTO tblWeeklyInput ( EmployeeID, StartDate )
SELECT tblEmployee.EmployeeID, [Forms]![frmsetup]![StartDate]
FROM tblEmployee LEFT JOIN tblWeeklyInput ON tblEmployee.EmployeeID = tblWeeklyInput.EmployeeID;

I need to have ALL the dates in the work week, not just the start date. How do I set this query up to add 5 days in a row to the same field?

As always Many Thanks!

[This message has been edited by RickR (edited 05-10-2002).]

[This message has been edited by RickR (edited 05-10-2002).]

 

[Rich]

Does that mean your entering dates in advance of data that might not yet exist?

 

[RickR]

Yes. Thru a form the user selects the start of the week then the append query runs. Currently I have an update query running that fills in separate fields for Monday thru Friday. What I would like to do is have a single field with Monday thru Fridays dates added to it.

[This message has been edited by RickR (edited 05-13-2002).]