J
Jamie Longmire
Hi,
I am a bit of a newby at Access and I am building a database whereby I can
identify the phone numbers on my phone bill with the actual number in my
contacts list.
I'd like the query to display records (Name and Number) from the Contacts
table that best match the number in the PhoneBill table
I know this is a simple query but I have an issue. The data in the number
field in the PhoneBill table can be stored in different formats e.g.
+61408123456 or +61 408 123 456 or 0408 123 456. The data in the number
field in the Contacts table can be stored like +61 (408) 123456 or +61 (408)
123-456
I have been playing around with this query to identify only the three last
digits in the number field but no luck.
I have two tables with respective fields:
1. PhoneBill
Date
Time
Number
Duration
2. Contacts.
Name
Number
Any input appreciated
Regards,
Jamie
I am a bit of a newby at Access and I am building a database whereby I can
identify the phone numbers on my phone bill with the actual number in my
contacts list.
I'd like the query to display records (Name and Number) from the Contacts
table that best match the number in the PhoneBill table
I know this is a simple query but I have an issue. The data in the number
field in the PhoneBill table can be stored in different formats e.g.
+61408123456 or +61 408 123 456 or 0408 123 456. The data in the number
field in the Contacts table can be stored like +61 (408) 123456 or +61 (408)
123-456
I have been playing around with this query to identify only the three last
digits in the number field but no luck.
I have two tables with respective fields:
1. PhoneBill
Date
Time
Number
Duration
2. Contacts.
Name
Number
Any input appreciated
Regards,
Jamie