<div>
MyNumber:Val([PropertyNo])<wbr /><br />
MyLetter: Right([PropertyNo], Len([PropertyNo]) - Len(Val([PropertyNo])))<br />
<br />

</div>


MyNumber:Val([PropertyNo])
MyLetter: Right([PropertyNo], Len([PropertyNo]) - Len(Val([PropertyNo])))



<div>
You are welcome!<br />
<br />
/gustav
</div>


<div>
<div class="content wysiwyg-content">
I have a table column that contains the property number, however some of the results are 22A if its a set of flats for eample. I wasnt to be able to split this column into 2 and have only numbers in one which will be property number and the letters into another column which will be called propsuffix. How can i do this. I have used the Mid and InStr to get this table in the first place but not sure if i can use this to get rid of letters only.<br />
<br />
Thanks
</div>
</div>


I have a table column that contains the property number, however some of the results are 22A if its a set of flats for eample. I wasnt to be able to split this column into 2 and have only numbers in one which will be property number and the letters into another column which will be called propsuffix. How can i do this. I have used the Mid and InStr to get this table in the first place but not sure if i can use this to get rid of letters only.

Thanks

Remove characters from property numbers in access

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.