inserting comma

[David Kennedy]

Hi,
I have a table with records in a field (data type text) ie
9900
100000
900
428
5522

Can anyone tell me how to insert a comma so that the data appears
99,00
100,00
9,00
4,28
55,22

thanks in advance
David K

 

[Nikos Yannacopoulos]

David,

Use the following expression in an update query (in the Update To line
in the query grid, under the field in question):

Left([Field1], Len([Field1])-2) & "," & Right([Field1], 2)

substituting Filed1 with the actual name of the table field.

HTH,
Nikos

 

[Wayne Morgan]

I suspect that what you're asking for is the normal way of displaying the
value in your locality settings. If so, try the Format and Decimal Places
properties of the control or field.