CODEWITHSUNDEEP
type-conversionms-access-2010
user776676
user776676

Reputation: 4385

Microsoft Access: How to convert number to string using update query?

I have an integer field with numbers ranging from 1000 to 99999. I want to convert this number field to a 5-character text field. This means all 4 digit numbers will have 0 added in front when converted to text. Example: 1000 in integer must be converted to 01000, etc.

How do I do this? Thanks.

Upvotes: 1

Views: 27252

Answers (1)

Craig T
Craig T

Reputation: 2742

In your query change the field to:

NewFieldName: format([OldFieldName],'00000')

This will convert the number to a text value.

Upvotes: 4

Related Questions