How to make make access marco that will convert several fields from numbers to text

How do you create a macro in Access 2003 that will convert several fields of numbers into text? To be more specific, I want to take an Ohio database of marriages and change the number of the county (there are 88 counties) to the name of the county. How can this be done with a macro?
kfranckAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

therealmongooseCommented:
You can do this without running any code - create a new table called counties with 2 fields - one being a numeric field which relates to the id of the county in the original table, and one being text which contains the text name of the county. Use a query showing both table and drag a link between the county (numeric field) inthe original table, and the numeric id field of the new table. This will then allow you to show the county names instead of the county number....

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
kfranckAuthor Commented:
Great. Thanks.
0
kfranckAuthor Commented:
Terrific help. Quick and thorough. Thanks.
0
therealmongooseCommented:
No probs - glad to be of help!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.