Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
What is the correct formulas for these Microsoft Access Database Queries?
What is the correct formula criteria for finding the list of names of people (first name, middle name and surname), for example, whose name has a letter used only once or a letter used twice only?
And what's the correct formula criteria for finding the names of people with less than, equal to OR more than 15 (or any number) characters in his/her name?
Please help?
1 Answer
- Jeff PLv 77 years agoFavorite Answer
1) I don't think Access has a way to do that--you may have to use VBA for that one.
2) You'll need a HAVING clause similar to this:
HAVING Len([FieldName]) >= 15
