Matching Tables

[Guest]

I have 1 table that has a number: 11-22-3333.
Another table has the same number in a different format: 11223333

Is there a formula that I can build into the query to reformat one of these
numbers to look like the other so I can match up additional data?

 

[Brendan Reynolds]

You can use the Replace() function to replace the hyphens with nothing ...

? replace("123-456-789","-","")
123456789

 

[Guest]

Assuming that the format of the field is always "##-##-####"
then you can create a query based on the first table with the unformatted
field
"Select format([MyField],"##-##-####") as aaa from MyTable"

then create another query where you can join the second table with the query
you created above.

 

[Guest]

You are my hero!

You can use the Replace() function to replace the hyphens with nothing ...

? replace("123-456-789","-","")
123456789