Query Help

[Scott]

I have a query built that brings back info based on a phone number I enter.
Is there a way to have the query ignore dashes in a phone number that I paste
into the query? I copy in 555-123-4567 but my data set has the number listed
as 5551234567. Thanks

 

[Dale Fye]

Scott,

It depends on how you are entering the phone number. Does this pop up for
entry as a parameter in the query? If so, post the SQL of your query.

You will probably need to wrap the parameter in the Replace( ) function, an
put that in the WHERE clause of your query. Something like:

WHERE [Phone] = Replace([Enter phone number], "-", "")

If you post your SQL I'll take a look.

Dale