Search results

I have a master record table which has thousands of fax numbers. I would like to remove the spacing infront of some numbers. I understand using the query Expr1: Replace([Fax]," ","") would help but how can I update into the master record table? Btw, the fax field is a primary key and Yes (No...

Hi all, I have a master database (mdb) with fax numbers but they are not in proper: some: +65, (065), 065, 65 and some symbols like ><= and so on. So I created this few query, 1st, Query to remove duplicate then from this query 2nd, Query to remove space then from this query 3rd, Query to...

Hi all, I am happy with my fax database until my goverment decided to add another 6 infront of all the phone and fax number. How can I change all the numbers together? Example from : 1234567 to 61234567 Thanks.

Hi, I have created a simple database named: tblcustomer.mdb with fields of Company, Address and Tel I would like to create another database which records the jobs that I have done for these companies. I name it tbljobrecord.mdb with fields of Company, job 1 and job 2 My question is, how can I...

Hi, I wanted to make Access 2003 search in a faster way. I have found this software call AZZ cardfile from the internet and it is very small and fast. It has a left panel with a text box for search expression and once you type something it will search straight away and display the results...

I have: Database A with fax numbers: Example: - 1. John. W - 2. Mark. Y - 3. Sean .S I exported to a dbf file to do some mass faxing and realised that Mark's fax number is no long in use. (error report by the fax software) I can export the error report and save as dbf. Is there a way to...