REPLACE CHARACTER "." WITH "-"

[xrookie]

Can someone please help me with something i thought would be relatively simple but its going to make me go nuts!! I am quite new to access and doesnt have much programming experience but i really do believe that this problem can be sorted out with a simple SQL query.I Have a text field with data looking like this:

2005.11.12
2002.05.14

I need it to look like this:

2005-11-12
2002-05-14

Its basically a normal find/replace operation but it should be done with a query or something that i can run so that i dont have to manually go and do the replace operation.Any help or suggestions would be greatly appreciated since this has been giving me grey hair for the past two days already!

Thanx.

 

[KenHigg]

Have you tried using the replace() function?

???

 

[Smart]

Re : Replace Character "." With "-"

If you place the following in your query

field1new: Replace([field1],".","-")

(where field1 is the field that contains your data (2005.11.12)

 

[Brianwarnock]

Isn't it confusing having 2 threads discussing the same topic?

Brian

 

[KenHigg]

And xrookie may never be back anyway