is there a nice way to insert a row from one identical table to the next
without having to longhand all the fields or even use a rs.fields(index) in
a loop?
thanks,
mc

Michael

Try SQL

INSERT INTO DestinationTable SELECT * FROM SourceTable WHERE
SourceTable.ID=SomeValue (or SourceTable.ID BETWEEN x AND y)

Sukesh