pauledwardian
asked on
Access replace comma (,) with dash (-)
This is the access file that I have and I need to replace the commas in ("WorkCodes") column to dashes but I dont know how to do it.
Please help!
Final-Access1.accdb
Please help!
Final-Access1.accdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
"How can I have this querry to create a table "
Change it to a MakeTable query ...
But, why not put that expression in the MakeTable query ... and do the conversion all at once ?
mx
Change it to a MakeTable query ...
But, why not put that expression in the MakeTable query ... and do the conversion all at once ?
mx
ASKER
Thanks!
ASKER
Open in new window
How can I have this querry to create a table after running and then it runs your code for the new created table:Open in new window