Manipulating data

[sharman]

Hi,

I am a newbie to Access Programming. I have a table in which the data looks
like this:
00001 - 00004 1990 MM
00005 - 00990 1990 NN
00991 - 00999 1991 KK
01000 - 01008 1992 LL

I have to write a macro that traverses through all the rows of data and does
the following manipulations to the data:

1. Creates another table with the fields number, year and code
2. Expand the range from the starting number to the ending number and prefix
the year and the code to the number and inserts it into the number field. The
new table will look like:

1990MM00001 1990 MM
1990MM00002 1990 MM
1990MM00003 1990 MM
1990MM00004 1990 MM
1990NN00005 1990 NN

I need some help for getting started on this thing. Thanks in advance.