Increment Database Version Number by 1

[SolerPower]

Hello

I’m working on a section of code that when a user clicks a button it looks at a table called TBLVersion and increments the version number. The version number format is 1.0.1 what I need the code to do is increment the last digit by one for example to “1.0.2”. I got the flowing code to work in excel but could not figure out how to translate it to access. Any help would be awesome.

=LEN(A1)-SEARCH(".",A1,SEARCH(".",A1)+1)
=RIGHT(A1,B1)

 

[plog]

You need to store discrete pieces of data, in their own fields. And you need to use the correct data types for those fields.

So, the value "1.0.1" should be stored in probably 3 fields, the last one should be numeric since you need to increment it. Then, to increment it, you can run a simple UPDATE query that adds 1 to the current value in that last field..