How do I make an "Option" Query

From: Jamie Longmire (jamie_longmire_at_hotmail.com)
Date: 01/30/05 

Date: Sun, 30 Jan 2005 17:04:23 +1100

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

Relevant Pages

  • Re: How do I make an "Option" Query
    ... > I'd like the query to display records from the Contacts ... > field in the PhoneBill table can be stored in different formats e.g. ... Make sure your form doesn't allow any format to be stored other than the one ...
    (microsoft.public.access.queries)
  • Re: How do I make an "Option" Query
    ... >I know this is a simple query but I have an issue. ... >field in the PhoneBill table can be stored in different formats e.g. ... better if you're covering several nations, break it up into country ... code 61, area code 408, and phone number 123456. ...
    (microsoft.public.access.queries)