Tables

[nathan]

i don't under stand what to do
can you explain further
or
can you creat it and e-mail me the file???
nathan_rob @ rogers.com

thanks

-----Original Message-----
) good,

I'm assuming that you don't want 1234569 followed by
1234567 followed by 1234565, but rather 1234569 followed
by 1234577 followed by 1234583.

easiest way I can think of is to create a Query on the
table include the column with the Order Numbers in (i'll
call it colA) and a new field called myField where -
myField: Mid$([Field1],5,4)

dim strLastOrdNum as String
dim strNewOrdNum as String
dim sglLastNum as Single

strLastOrdNum = DLookup("ColA", "Query1", "myfield = " &
DMax("myField", "Query1") & "")

If Right(strLastOrdNum,1) = 1 Then
sglLastNum = 8
ElseIf Right(strLastOrdNum,1) = 0 Then
sglLastNum = 9
Else:sglLastNum = (Right(strLastOrdNum,1) - 2)
End If

strNewOrdNum = "LLLL" & (DMax("myField", "Query1")+1) &
sglLastNum

Bit long winded, probably better ways, but it's been a
long day!!!!

TonyT

-----Original Message-----
oh yes the 0 after the 3 could be a 1



3
0