Telephone Number Format

From: The Grape Hunter (TheGrapeHunter_at_discussions.microsoft.com)
Date: 12/30/04 

Date: Wed, 29 Dec 2004 21:49:02 -0800

Have table of about 11,000 records. Table design was NOT set up to store
phone numbers without format. They have been entered and stored in (333)
444-5555 format. Query works fine if they are asked for in the displayed and
stored format. The users fumble with the correct entry for the query and
would rather just key in the raw 10 digit sequence. ( ie 3334445555) for the
query. I have changed the field definitions in the table design, but that is
not fixing the stored data. If I go back and retype a phone number in, that
entry becomes accesible to the raw number query. How could I automate or fix
in some other fashion how these phone numbers were previously stored?

Thanks for your great help.( I know the answer is out there!)

Relevant Pages

  • RE: case sensitive join
    ... You could try going into Design View and either checking the format of the ... display) your records of that column in a uniform format. ... If you still get duplicate results, check your query results to see ...
    (microsoft.public.access.queries)
  • RE: Saving Query as Word Document changes the look of data
    ... I designed a query in Access, to give me just the Cities, States & Zip Codes ... I then wanted to have it in a word processing format so that I can ... The text of each field, however, appeared with quotations around it, e.g., ... Can I change the design somehow so that when it's ...
    (microsoft.public.access.queries)
  • RE: how to sort columns in cross tab query
    ... The table format will not flow through to the query output. ... Open the crosstab query in design view. ... Expand the column that has your date field. ...
    (microsoft.public.access.queries)
  • Re: MakeTable Query -- Field Must be "Double" vs. "Decimal"
    ... You will still need to open your table in design view, and set the Format to ... > In a "MakeTable" query, I use an expression that calculates the following ... > When I execute the query, field "Total" always becomes a "Decimal" data ...
    (microsoft.public.access.queries)
  • [OT]? SQL or Program Code?
    ... The present design and implementation therefore possess several ... the number format should be processed. ... DBMS level at all. ... stopping them from doing this themselves in their controller and then ...
    (comp.sys.hp.mpe)