Hello would somebody please help me to work out this append query?
INSERT INTO tbl_AppendTimesheetInput ( FirstName, LastName, JobNo, [Sub Job], Hours, [Hourly Charge], Amount, Division, RegoNo )
SELECT DISTINCT
'These fields are on subform 1 (This is working)
tbl_Employee.FirstName...