need delete query to ignore 1st record in table

[pungentSapling]

I need to modify a delete query so that it will leave the first record in a table intact.

The problen is this... I have a two table "archiving" system that uses an append query(to add data to "archive") followed by a delete query(to remove data from "temp"). I need to leave 1 "dummy" record in the temp table so that my form does not generate errors-it uses queries to gather the last entered date and employee number from the temp table. When there are no records in the temp table I get errors because of the null data. The "dummy record will act as the default date and employee number settings.
thanks
p

 

[pungentSapling]

I got it working by setting the criteria in the append and delete queries to only take record entries higher than my dummy entry...
It Works..