Search results

Btw, I can't seem to copy the copy and paste the structure of my table. (to use append to remove duplicates) It says maximum 65000 records. So how can I remove duplicates in Access 2007?

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...

I use the replace function instead and it works well. Thanks. Another thing is that I am just trying out this wildcard # and ?. I understand # means alphabet and ? means numbers. (Am I right?) When I try a query the *#* works and only display the alphabet but the *?*didn't seems to

Thanks. I tried the wildcard *#* and it only display the alphabet, but why *?* doesn't display only numbers?

Thanks. The In(7,8) works well. One more question please. I have another database from someone else, his input is 1234 5678 but mine is 12345678, how can I remove that spacing in the middle?

Thanks. Just curious, how can I ask for 7 digits and 8 digits to be displayed together? I tried "=7 and 8" it didn't work out...:)

Thanks guys, for a simple user like me, the 6 & [FaxFieldName] works well. One more question, I found out that there some fax numbers that are not key in correctly, some less 1 digit, some extra 1 digit. How can I remove all these?

I tried under design view -> criteria and input 6+000000 but it doesn't work.

May I know where to input the 6+oldvalue?

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.

Thanks for the help. I manage to try out and link the 2 tables and it works. But when I try to create form, the link didn't show up as it is in datasheet view. Any idea? Shapshots: http://techland.com.sg/Example.html

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...