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 remove +65 then from this query
4rd, Query to remove 65-
and...
MaMister
Last Activity: Jun 1 '08, 01:22 AM
Joined: Sep 27 '06
Location:
-
Oh sorry, I did the replace and it works well. Thanks.
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 work. -
Thanks.
I tried the wildcard *#* and it only display the alphabet, but why *?* doesn't display only numbers?Leave a comment:
-
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?Leave a comment:
-
I finally got it, its len(FieldName) and =7 in criteria.
Thanks folks.
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...:)Leave a comment:
-
Sorry, what do you mean? If I choose delete query, where to key and what is the full command that I need to key?Leave a comment:
-
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?Leave a comment:
-
Adding another number digit into my fax database.
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. -
Removing outdated records.
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 make use of this dbf to update and remove Mark's record from Database A?
No activity results to display
Leave a comment: