Automatically Creating Records - Access

Associate
Joined
18 Oct 2002
Posts
2,161
Location
Here!
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
 
Associate
Joined
18 Oct 2002
Posts
2,161
Location
Here!
Can anyone please help with this? Its doing my head in! lol

Thanks a lot,

Ross
 
Top Bottom