Microsoft access sql convert text number

One more thing, how do I convert the real number to text format in a query? I need to convert text data stored in a field from this format to: 1. This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread. I have the same question Report abuse. Details required :. Cancel Submit. How satisfied are you with this reply? An example would be: a numeric field is called Quantity, in this case the command to convert the numbers representing a Quantity, to text would be: QuantityText:Cstr [Quantity] Go to the Design tab and in the Results group click on Run.

A warning message will appear, to run the query and update the results click Yes. There are no restrictions on converting numbers to text, however there are some restrictions on some data type conversions and you should check this before using other update functions.

In her spare time she loves to go to the gym and dress making. Average Rating. Click here to add your own comments. Join in and write your own page! It's easy to do. Simply click here to return to Microsoft Access Tips to Share. Privacy Policy Simply-Access.

Trying to do one project but don't understand how to do this can you please help me. Viewed 22k times. CodeMed CodeMed You may have to export all the data, get the database setup properly either edit the existing database after removing all the previously exported data OR Create a NEW copy of the database then import the data into the database to get everything back in place.

I had to do it once before on a project and it saved the day. Here is the link to the question: stackoverflow. Add a comment. Active Oldest Votes. Do you have any solution to my next question? You can read it at this link: stackoverflow. Sign up or log in Sign up using Google.

Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown.