Converting numeric data to text

G

Gingerbread

Sorry if this is posted a second time.

I am trying to convert a numeric field to text fin a query. the numeric
values are either 2 or 3 digits but I want the results to be 5 characters. I
want to use a function similar to the text function available in excel, ie
[test,rc,"00000"].

Is there something similar in access?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting a numeric field to text 1
Converting URLs in comments to Markdown-formatted links 2
Formating bolded text exclusively. 0
Loop Through Text and Test for Scenarios Q 31
Prompt For Replace in Selection And More... 0
Text Formatting of Expression Based Query Columns 0
find and replace numeric strings in larger text strings 8
Ignore Leading Zeros in Mixed Alpha-Numeric Text Fields Select Query 5

Top