[RESOLVED] Duplicating a record in a database

[dfuas]

Hi Guys,

I have a problem which is:

I am entering information in an Access database using a form. I want to be able to duplicate data, say I have 45 entries in a database and I need to have number 15 entry twice, such that if I hit a dupplicate button while on entry 15, this is entered as 15A and 15B. e.g the sequency of entries becomes 13, 14, 15, 15A, 15B, 16, 17...,etc.
Is this possible? Can you help

Thank you

Dinis

[Ed Lampman]

Use an autonumber field and enter the duplicate record as normal. Use another field (unique) called something like 'SequenceNumber' and assign your 15B etc to that field.

Then, when you query the database, just sort on the SequenceNumber field and the records will appear in the order you want.