translate numbers to text

[jermaine clarke]

Hi all!

I would just like to know if someone could help me figure out how I could translate numbers to text for a report that i would use for my cheques and payment receipts.

thnx

 

[CraigDolphin]

maybe use the CStr() function to convert numeric values into text

 

[jermaine clarke]

its no use unless i'm not using it correctly. please gi me an example.

 

[jermaine clarke]

please bear in mind too that I want to do the conversion in a report

 

[mhartman]

Hello:

Or, here is an article on the matter:

http://support.microsoft.com/kb/210586/en-us

Regards
Mark

 

[KeithG]

What do you mean numbers to text? Change 1 to one? Or are you talking data types?

 

[CraigDolphin]

Ah...reading Mark's link made me reinterpret your question.

I thought you were wanting to convert from a numeric datatype to a text (or string) datatype. If you are wanting to convert from numbers to english words then Mark's link is spot-on.

So, my solution helps turn 7 (numeric) into '7' (text)
Mark's link would convert 7 (numeric) into seven (English)

 

[jermaine clarke]

i'm not very familiar with functions. can someone plz provide me with the steps as to how to make the function actually work. does it apply to reports?

 

[doco]

Is the report generated by a query resident in Access or in VBA code, or control source string, or ????

Access Query

text_num: CStr([number_field])

In Code or string

SELECT 
      tbl_test_nums.id
    , CStr( [number_field] ) AS text_num
FROM 
    tbl_test_nums
WHERE 
    ( ( ( CStr( [number] ) )<20 ) );

Pretty cheezy example but hope it gives you the idea

 

[jermaine clarke]

re: currency to numbers

thnx to all. I have successfully converted currency to text.