auto increment text

  • Thread starter Thread starter matt via AccessMonster.com
  • Start date Start date
M

matt via AccessMonster.com

Hey guys

I am very much a rookie so any help is much appreciated.

What i have is field that contains text which is representative of a
fixture number. A typical fixture number would be CJ5796-108C

What i want to do is find the biggest number that the last 3 digits would
be so when the add a new record the next number is automatically there.

The problem is i have a table with 1100 fixtures numbers or so. I want the
user to enter a number which would match the first portion of the number
such as CJ5796 then the code should select all fixture numbers with this
number then take the last 3 or 4 digits of the field such as 108C and find
the largest number and add 1. Is this possible?
 
Hello and thanks for the response. I was hoping that i wouldn't have to
manually go through and change all the fixtures into 3 different fields.
But i am absolutly positive that i have to change them and then concatanate
them to make the sorting work.

Thanks very much for you time

Matt
 
Back
Top