TonyEF
asked on
Convert Numbers to Text
I have two fieds in a table:
Application Year
Appication Number
the Application Year is the last two digits of the year, such as "98","99","00","01",
the Applicaton Number is an eight digits number, such as "00000150", "00000151",
I am combining the two fields to create a new table with an unique field like :
Inspection Number: [Application Year] & " -" & [Application Number]
the issue that I am having is the the leading zeros for each of the fields are dropping and it looks like this "98-150", "0-151"
I need assitance be able to retail the leading zeros for each of the fields when I combine the two fields please.. I like to see it look like this : "98-00000151", "00-00000151",
I want the the year to retain the first two digits and the Application Number to be 8 digits.
Application Year
Appication Number
the Application Year is the last two digits of the year, such as "98","99","00","01",
the Applicaton Number is an eight digits number, such as "00000150", "00000151",
I am combining the two fields to create a new table with an unique field like :
Inspection Number: [Application Year] & " -" & [Application Number]
the issue that I am having is the the leading zeros for each of the fields are dropping and it looks like this "98-150", "0-151"
I need assitance be able to retail the leading zeros for each of the fields when I combine the two fields please.. I like to see it look like this : "98-00000151", "00-00000151",
I want the the year to retain the first two digits and the Application Number to be 8 digits.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're right, my mistake. Looks like you figured it out. :-)
ASKER
the answer of the expert was not completed...