Thanks Gregory, your solution is perfect!
May I ask another quick question? I have a command button on a form that appends records from one table into another and the records being appended all have the same date. Can you help with an IF....EndIf statement that will prevent the records from being appended if the dates for the records are already there (because the user may have previously performed the append but is trying to do it again and I don't want the same names with the same dates appended twice).

The sql I am using now is:
SELECT table2
Append From table1

Thanks again!
Max
>max,


>REPLACE table1.field with table2.field ;
all for (Table1.emp_number + dtoc(table1.dateWork)) == (Table2.emp_number + >dtoc(table2.dateWork))

>&& better is to used dtos() instead of dtoc()

>Gregory