Susan Harkins
ssharkins at gmail.com
Thu Dec 6 13:36:23 CST 2007
You just create an append query Arthur and set the ANPK's field to one less than you want the first value to be -- just open a fixed query in Design view, choose Append from the Query menu, specify the table... run it. Open the table, delete the record you just appended. Susan H. >I figured it was something like that, but how do I append a record and >force > the value of the ANPK? Not sure how.