Solved

Remove characters from property numbers in access

Posted on 2007-03-22
4
189 Views
Last Modified: 2012-05-05
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
0
Comment
Question by:martgriff
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 50

Accepted Solution

by:
Gustav Brock earned 250 total points
ID: 18771493
Use:
   Val(PropertyNo)

and

   Right(PropertyNo, 1)

/gustav
0
 
LVL 39

Expert Comment

by:stevbe
ID: 18771567
MyNumber:Val([PropertyNo])
MyLetter: Right([PropertyNo], Len([PropertyNo]) - Len(Val([PropertyNo])))

0
 

Author Comment

by:martgriff
ID: 18771571
Thanks alot for that :D
0
 
LVL 50

Expert Comment

by:Gustav Brock
ID: 18772019
You are welcome!

/gustav
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question