Zip code filtering

  • Thread starter Thread starter Zack
  • Start date Start date
Z

Zack

How can I filter a database so that in the zip code field, a 5 digit zip code
is not unique from a duplicate record where the same record is listed but
with 9 digits?
 
you'd want to have a column with =left(value,5) formula to look at only the
first 5 characters.
 
Back
Top