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
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