Updating characters to the next in sequence

[andrimitum]

Hi,

I am working on a database which tracks drawing numbers/ letters. I have created a form / query which creates new revisions but would like to automaticaly go to the next number / letter in sequence. sometimes it is a number somtimes a letter.

Version A should become Version B, Issue 1 should become Issue 2 which would be easy if it were a number but it must be treated as a text string.

how would I do this?

Thanks

 

[PHV]

A starting point:
strNextRev = Left(strRevision, Len(strRevision) - 1) & Chr(1 + Asc(Right(strRevision, 1)))

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[MichaelRed]

search these fora for something like basIncrA I recall seeing a few different versions, some of which include 'carry' of the character).




MichaelRed

 

[TheAceMan1]

How are ya andrimitum . . .

Hmmm . . . are you saying the same field can have a [blue]Version[/blue] or [blue]Issue[/blue]? . . .

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[andrimitum]

Thanks all for posting, I have not been back to my desk since I asked the question so have not had time to try the suggestions. I will on Monday though.

@ TheAceMan1/
Currently yes Issue and Version are being used interchangeably, just another thing that will have to get fixed but it requires a rethink of how things have been done in the office. One of the advantages of creating a database, everyone has to finally decide how they want to store and retrieve information.

thx

 

[andrimitum]

Thx PHV

it worked perfectly,

Thanks all.