CONCAT and SubStr in access

Hi..I urgently need the solution on the following case....please help

1. I would like to make a select statement using substr..but the access cannot process my query...it said the "substr" is not a valid command...

2. I have a field in the table to store the tel of client, some of the reocrd contact a "space" in-between the tel number...what is the fastest way to find out those record and correct them to "without space" in access??
esther_6694Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
fulscherConnect With a Mentor Commented:
esther 6694, concerning the 1st question: please post the query as you have it now.

Concerning the second question: first create a normal query:
SELECT (replace(tel, " ", "")) from tablename;
and check whether this gives the results which you need. If so, you can create an update query to fix the fields (make a backup first!!!):

UPDATE table SET tel = Replace([tel]," ","");

Hope this helps
Jan


0
 
solution46Connect With a Mentor Commented:
The commands you need are Mid() for SubString and Replace() to get rid of the spaces.

The Access online help should tell you all you need to know about these functions.

s46.
0
All Courses

From novice to tech pro — start learning today.