Automatically Creating Records - Access

[Ross]

Hi,

I'm trying to create a form which has the following fields:

First Serial Number, Last Serial Number, Succeeding Letter

I then want the form to automatically create records in a table where the field SerialNumber is automatically created; using the range specified and adding the succeeding letter after each number.

eg.
First: 123001
Last: 123005
Letter: J

Would create records in the table with the following serial numbers,

123001J
123002J
123003J
123004J
123005J

Can anyone help?

Ross

 

[Ross]

Can anyone please help with this? Its doing my head in! lol

Thanks a lot,

Ross