Converting numerical value to text

[Alojz]

Hi,
what formula can I use to convert numerical value consisting of 10 digits
with no decimal points to text string? Something similar to T or TEXT
function in Excel. I am new to Access and would need this to know urgently.
Thanks in advance,

Alojz

 

[Allen Browne]

Perhaps you need something like this:
Convert Currency ($500) into words (Five Hundred Dollars)
at:
http://www.mvps.org/access/modules/mdl0001.htm

 

[Alojz]

Hi, not really. I need to concatenate 10 digits defined as number located in
one field with 2 or 3 digits defined as number located in other field.
Purchase order: 4300069000
Line #: 10
I would need to concatenate these two to the string like: 4300069000-10 to
get unique key for each line in PO table.
When I try formula: [Objednavky]![Purchorde] & "-" & [Objednavky]![Line]
in query, I get 4,30006E+09-10 as a result. I would need access not to
convert the PO number to scientific format.

 

[Allen Browne]

Okay, the Format function should give you the string you want.

Something like this:
Format([Purchorde], "#.0##############") & "-" & [Line]

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Hi, not really. I need to concatenate 10 digits defined as number located
in
one field with 2 or 3 digits defined as number located in other field.
Purchase order: 4300069000
Line #: 10
I would need to concatenate these two to the string like: 4300069000-10 to
get unique key for each line in PO table.
When I try formula: [Objednavky]![Purchorde] & "-" & [Objednavky]![Line]
in query, I get 4,30006E+09-10 as a result. I would need access not to
convert the PO number to scientific format.

Perhaps you need something like this:
Convert Currency ($500) into words (Five Hundred Dollars)
at:
http://www.mvps.org/access/modules/mdl0001.htm

 

[Alojz]

Yes Allen, was trying hard in the meantime and get same result. Starting to
do something serious in Access first time in my life and being often easily
lost these days. Thanks

Okay, the Format function should give you the string you want.

Something like this:
Format([Purchorde], "#.0##############") & "-" & [Line]

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Hi, not really. I need to concatenate 10 digits defined as number located
in
one field with 2 or 3 digits defined as number located in other field.
Purchase order: 4300069000
Line #: 10
I would need to concatenate these two to the string like: 4300069000-10 to
get unique key for each line in PO table.
When I try formula: [Objednavky]![Purchorde] & "-" & [Objednavky]![Line]
in query, I get 4,30006E+09-10 as a result. I would need access not to
convert the PO number to scientific format.

Perhaps you need something like this:
Convert Currency ($500) into words (Five Hundred Dollars)
at:
http://www.mvps.org/access/modules/mdl0001.htm


what formula can I use to convert numerical value consisting of 10
digits
with no decimal points to text string? Something similar to T or TEXT
function in Excel. I am new to Access and would need this to know
urgently.