Spiliting up a Post code

[Simon]

I have a field in a report that displays a UK post Codes like TN23
8LP

I would like to slipt it up into lots of fields in a report

eg

First Charater = T
Second Charater = N
Third Charater = 2
Forth Charater = 3
Fifth Charater =
Sixth Charater = 8
Seventh Charater _L
Eighth Charater = P


Thanks

 

[Guest]

Hi Simon

Use the Mid function like...

=Mid(Postcode, 1, 1) Gives 1st character
=Mid(Postcode, 2, 1) Gives 2nd character
=Mid(Postcode, 3, 1) Gives 3rd character
etc

hth

Andy Hull

 

[Tony Toews [MVP]]

I have a field in a report that displays a UK post Codes like TN23
8LP

I would like to slipt it up into lots of fields in a report

Why? What's your objective or problem you are trying to solve?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/