Queries by case

[pattrickcolin]

Within a query I wish to restrict all fields where it is lower case only.
E.G.
A, Aa, aAb....... is returned

Whilst
a, aa, aab..........is not returned

[orange]

By default access is case insensitive.
If you want to test for lowercase, I suggest you look to vba and use the asc() function.

see http://www.techonthenet.com/access/f...string/asc.php

[Bob Fitz]

My suggestion would be to add the following function to a module in your db:

Public Function CountCapitals(strInspect As String) As Integer  CountCapitals = 0
  If strInspect & "" = "" Then Exit Function
  Dim StrLn As Integer
  For StrLn = 1 To Len(strInspect)
    Select Case Asc(Mid(strInspect, StrLn, 1))
      Case 65 To 90
      CountCapitals = CountCapitals + 1
    End Select
  Next StrLn

Then add the following Where clause to your query:
WHERE (((CountCapitals([YourTextField]))>0))

Replace YourTextField ​with the name of your field.