Append Help!!

[sysop470]

I have a table which contains 50 employees. I have another table which stores the DATE LEAVE TAKEN for every employee. My difficult is how can i append for example a PUBLIC HOLIDAY DATE to all employee at the same time, instead of inserting the date one by one.

I have a form with a DATE field and a command button UPDATE but it does not work for me.. Any Help please....

Dim db As DAO.Database
Dim rs As DAO.Recordset

Set db = CurrentDb()
Set rs = db.OpenRecordset("LC", dbOpenDynaset)

rs.AddNew
rs![Date Taken Leave] = Me.Text1
'rs![Counter Leave] = Me.Counter_Leave
rs.Update
rs.Close
Set rs = Nothing
Set db = Nothing

 

[pbaldy]

Try

INSERT INTO SecondTableName(PersonField, DateField)
SELECT PersonField, #2/3/09#
FROM FirstTableName