Hello,
Hope I am in the correct forum!
Problem:
I have an access table containing +- 3000 records (call it table 1).
One of the fields (call it ID) contains data (short text) formatted as follows: xx-yy-zzz or xx-yy-zzzz where xx, yy and zzz(z) are figures.
I want to recreate a table (table 2) where field 1 (call it Ident) is formatted as autonumber [with format xx-yy-zzz(z)] and then fill this table in the way that the data of table 1 are transferred to table 2 with ID = Ident.
In other words: in table 2, if Ident is 01-01-001 then the record should contain the data of the record in table 1 where ID is 01-01-001
To be complete: in table 1, not all ID figures are used: example: 01-01-002, next is 01-01-004 (no 01-01-003!).
I am NOT a whizzkid, so if possible, step-by-step would be appreciated!!
thanks ever so much for help!!
LVL