<div>
do you mean upper or lower case a to z characters?<br />
if so you would need to loop through that table and check every individual character (loop) in that field in usng the asc function (ascii function):<br />
asc(&quot;A&quot;) returns 65 <br />
asc(&quot;Z &quot;) returns 90<br />
<br />
asc(&quot;a&quot;) returns 97<br />
asc(&quot;Z &quot;) returns 122<br />
<br />
so every character needs to be between 65 to 90 OR between 97 to 122, mutually exclusive<br />
if you get a field with a mix of characters between 65 to 90 ANd between 97 to 122 the you its a mix of lower and upper case
</div>


do you mean upper or lower case a to z characters?
if so you would need to loop through that table and check every individual character (loop) in that field in usng the asc function (ascii function):
asc("A") returns 65
asc("Z ") returns 90

asc("a") returns 97
asc("Z ") returns 122

so every character needs to be between 65 to 90 OR between 97 to 122, mutually exclusive
if you get a field with a mix of characters between 65 to 90 ANd between 97 to 122 the you its a mix of lower and upper case

<div>
<div class="content wysiwyg-content">
I have a file of names where some are properly cased and some are all lowercase and some are all uppercase. &nbsp;I am interested in only viewing the names in the table that are all uppercase or all lowercase. &nbsp;How do I achieve this through MS Access?
</div>
</div>


I have a file of names where some are properly cased and some are all lowercase and some are all uppercase.  I am interested in only viewing the names in the table that are all uppercase or all lowercase.  How do I achieve this through MS Access?

Limit Query Results

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.