How to Convert Number to Text in Access Query

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
You can change field type using a query.

Microsoft is a powerful and widely used database program and the query function is one of the most useful parts of the program. Database administrators and ordinary users can use the query function to get real-time information from the database; queries can even display the data in an alternative format. Converting a numeric field to text can make the query results more useful and easier to transfer to other programs.

Advertisement

Step 1

Log on to your computer and open the Microsoft Access database you want to use. Click on the "Queries" section of the database.

Video of the Day

Step 2

Double-click "Create query in design view" and choose the table on which the query will be based. Double-click each field you want to display in the query.

Advertisement

Step 3

Place the cursor in the first blank column and type "TextField: Cstr([NumberField])" in the "Field" box. Replace "TextField" with a descriptive name and "NumberField" with the name of the numeric field. For instance, if the numeric field is called "Cost," the command would be "CostText: Cstr([Cost])"

Advertisement

Advertisement

Step 4

Click the "Save" button on the toolbar to save the query. Give the query a descriptive name. Double-click the new query to run it.

Video of the Day

Advertisement

Advertisement

references