<div>
Assuming it is ALWAYS a single letter followed by digits...<br />
<br />
<br />

<pre><code id="code-20-37027924-1">UPDATE SomeTable
SET MyColumn = Left(MyColumn, 1) &amp; Format(Val(Right(MyColumn, 6)) + 1, &quot;000000&quot;)</code></pre>
</div>


Assuming it is ALWAYS a single letter followed by digits...




UPDATE SomeTable
SET MyColumn = Left(MyColumn, 1) & Format(Val(Right(MyColumn, 6)) + 1, "000000")

<div>
matthewspatrick<br />
<br />
Thank you for you reply. At the moment there is only one character but might change latter. I thought about using the Left() function<br />
<br />
Alan
</div>


matthewspatrick

Thank you for you reply. At the moment there is only one character but might change latter. I thought about using the Left() function

Alan

<div>
matthewspatrick<br />
<br />
Is there away to detect how many characters if so problem solved<br />
<br />
Alan
</div>


matthewspatrick

Is there away to detect how many characters if so problem solved

Alan

<div>
matthewspatrick<br />
<br />
Many thanks Patrick<br />
<br />
Alan
</div>


matthewspatrick

Many thanks Patrick

Alan

<div>
matthewspatrick<br />
&nbsp;Hi Patrick sorry to trouble you<br />
Getting error missing end bracket. I copied and pasted <br />
<br />
SET SomeColumn = RegExpFind([SomeColumn], &quot;\D+&quot;, 1) &amp;&nbsp;Format(Val(RegExpFind([Som<wbr />eColumn, &quot;\d+&quot;, 1)) + 1, &quot;000000&quot;)<br />
<br />
Alan
</div>


matthewspatrick
 Hi Patrick sorry to trouble you
Getting error missing end bracket. I copied and pasted

SET SomeColumn = RegExpFind([SomeColumn], "\D+", 1) & Format(Val(RegExpFind([SomeColumn, "\d+", 1)) + 1, "000000")

Alan

<div>
matthewspatrick<br />
<br />
Found it missing ] SomeColumn<br />
<br />
Alan
</div>


matthewspatrick

Found it missing ] SomeColumn

Alan

<div>
<div class="content wysiwyg-content">
Hi EE<br />
<br />
I have a problem updating a number. Problem the number starts with a character. Here is an example<br />
C000001<br />
D000001<br />
R000001<br />
They are project numbers once used they are updated by one. I tried separating the Character from the number then appending on the form but the user wants the leading zero's shown. Any help appreciated<br />
<br />
chestera
</div>
</div>


Hi EE

I have a problem updating a number. Problem the number starts with a character. Here is an example
C000001
D000001
R000001
They are project numbers once used they are updated by one. I tried separating the Character from the number then appending on the form but the user wants the leading zero's shown. Any help appreciated

chestera

Update a number

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.