Adding a record for a particular date using an append query

S

scubadiver

I already have the following SQL for adding a new record based on the
previous date.

INSERT INTO Department ( EmployeeID, WeekID, Dept, Subdept, Costcentre,
Contracthrs, timehalfhrs, doublehrs )
SELECT DISTINCT Department.EmployeeID, DMax("[WeekID]","Department")+7 AS
Expr1, Department.Dept, Department.Subdept, Department.Costcentre,
Department.Contracthrs, Department.timehalfhrs, Department.doublehrs
FROM Employee INNER JOIN Department ON Employee.EmployeeID =
Department.EmployeeID;

Just as a one off I want to add a new record for every employee for the date
30/6/2006.

Cheers
 
Top