Between...And Operator

  • Thread starter Thread starter Randal
  • Start date Start date
R

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?
 
You might use criteria like

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

on your SSN number field to select only records with valid SSN numbers.
 
Thanks a bunch. This works great.

Brian Camire said:
You might use criteria like

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

on your SSN number field to select only records with valid SSN numbers.
Click to expand...
 
Back
Top