Text Manipulation 2

[marcoman44]

I am trying to manipulate text just like you can do Excel with the Text function.

Here is the text field.

Example 1: 123456
Solution 1: 00123456*01

Example 2: 12345678
Solution 2: 12345678*01


Note: Characters before the *01 should be 8 and if not then add leading 0s.

I am trying to figure out how to do this in Microsoft Access Query.

Any help is greatly appreciated.

Thanks

 

[lespaul]

I'm pretty sure it's:

SELECT Format(FieldName, "00000000") + "*01" From TableName

Leslie

 

[PHV]

In the query grid:
Solution: Format([Example field],'00000000') & '*01'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244