Newbie - First post - Simple Question (1 Viewer)

[rvdsabu4life]

Thanks in advance for any help anyone can give on this.

I have a table with 3 fields

Field 1 is customer name (text)
Field 2 is sales date (date/time)
Field 3 is saleperson initials (text)

How would I create an advanced filter so that I can sort field one by the number of characters in the name.

For example this has old customers that just have initials as the name. It is my job to update the initials to the actual name. This contains 30,000 names in that field. So it would be helpful if I could filter by 3 or 4 characters.

Thanks!

 

[Rabbie]

The LEN function will give you the length of a text string so if you filter customer name like

Len([customer name]) < 5 then you should get what you are looking for.

 

[rvdsabu4life]

Awesome! Thanks so much!

 

[Rabbie]

Glad I was of help.