Between...And Operator

[Randal]

I am trying to use (Between "000-00-0001" And "999-99-9998") on SSN numbers
in a text field to exclude bad SSNs with alpha characters, but it doesn't
seem to work out. Alternatively, I can look at each character individually
to test if it is (Between "0" And "9") but it is not a very clean way to do
this. Is there an easy way to test for alpha vs. number in a text field?

 

[Brian Camire]

You might use criteria like

Like "###-##-####"

on your SSN number field to select only records with valid SSN numbers.

 

[Randal]

Thanks a bunch. This works great.

You might use criteria like

Like "###-##-####"

on your SSN number field to select only records with valid SSN numbers.