I'm working in a query in Access 2003 and I need the "ProgramCode" field to return a 5 digit alphanumeric code with leading spaces. The program codes are actually 1 to 3 character alphanumeric codes. I can get it to work with numeric codes only, but I'm having a problem with alphanumeric. I'd appreciate any help I can get.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Add Leading Spaces 2
- Thread starter lucybelle
- Start date
-
1
- #2
SkipVought
Programmer
hi,
Can you give examples?
Skip,
[sub]
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
Just traded in my old subtlety...
for a NUANCE!![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
[/sub]
Can you give examples?
Skip,
[sub]
Just traded in my old subtlety...for a NUANCE!
[/sub]-
1
- #3
- Thread starter
- #4
SkipVought,
I'm exporting a text file from Access so that I can ftp the file in the format that is required. Below are the instructions given to me .
ProgramCode must be a 5-digit alphanumeric code such as
‘ Z’. All program codes currently are only 1 to 3 digits and must have leading spaces.
PHV,
I tried your suggestion and it worked.
Right(" " & ProgramCode, 5)
Thanks to both of you!
I'm exporting a text file from Access so that I can ftp the file in the format that is required. Below are the instructions given to me .
ProgramCode must be a 5-digit alphanumeric code such as
‘ Z’. All program codes currently are only 1 to 3 digits and must have leading spaces.
PHV,
I tried your suggestion and it worked.
Right(" " & ProgramCode, 5)
Thanks to both of you!
- Status
Similar threads
