Numbers as Text: When to Store Numbers in a Text Field in Microsoft Access. Val Function.

In this Microsoft Access tutorial, I'm going to explain when you should and should not store numeric data in a text field. Then I'm going to show you how to take numbers stored in text fields and properly sort them with the Val function.

LEARN MORE:
https://599cd.com/NumbersAsText

RECOMMENDED COURSES:
Access Beginner 1: https://599cd.com/ACB1
Access Beginner 3: https://599cd.com/ACB3

LINKS:
No Longer Set: https://tinyurl.com/279v8szy
String Functions: https://599cd.com/StringFunctions
Calculated Fields: https://599cd.com/Calculated

BECOME A MEMBER:
YouTube: @599cd
or My Site: https://599cd.com/THMember

ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter: Twitter: LearningAccess
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...

KEYWORDS
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #fasttips, why store numbers in a text field, When to Store Numbers as Text, val function, text to number

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

• #education
• #access_2016
• #access_2019
• #access_2021
• #access_365
• #microsoft_access
• #ms_access
• #ms_access_tutorial
• #msaccess
• #microsoftaccess
• #help
• #howto
• #tutorial
• #learn
• #lesson
• #training
• #database
• #fasttips
• #why_store_numbers_in_a_text_field
• #when_to_store_numbers_as_text
• #val_function
• #text_to_number