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?

Jeff P2014-02-08T16:34:03Z

Favorite 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

00

Related Questions

Microsoft Access Queries: Calculating Sales of each Product within Date Range?How can I replace only certain values from one table to another in Microsoft Access?How to insert Today's date but from another computr's date?Microsoft Access 2010_Database Project_Queries?Database Microsoft Access, Query?

Trending Questions

What were your covid 19 vaccine side effects?14 answersCovid 19 face mask?12 answersWhich software is best for editing? ?23 answersDid you like being on lockdown during covid?20 answersdoes covid 19 turn people into zombies?4 answers