MS Access separate comma delimit?

buddy

Actually the field is like this

Field1

20,6

22,9

32,3

12,3

but I Want to change like this

Filed1 Field2

20 6

22 9

32 3

12 3

I want to move the numbers which are next to comma "," to the next field in ms access

if any body have Modules plz help

marco-savastano

.....xD

austine

a particularly uncomplicated thank you to try this's: a million. upload Field2 to the table 2. keep the replace 3. run an replace question to repeat field1 to field2 4. run queries to replace each and every field with its needed element OR create a technique that loops via a recordset to replace the fields: whilst no longer rs.EOF   i = InStr(rs!field1, ",")   If i > 0 Then     rs.Edit     rs!field2 = Mid$(rs!field1, p + a million)     rs!field1 = Left$(rs!field1, p - a million)     rs.replace   end If   rs.MoveNext Wend