Avatar of TonyEF
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.
Microsoft Access

Avatar of undefined
Last Comment
TonyEF

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
IrogSinta

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
TonyEF

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
IrogSinta

You're right, my mistake.  Looks like you figured it out. :-)
ASKER
TonyEF

the answer of the expert was not completed...
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23