Splitting Upper and Lower Case text in a Query
If you have a field that contains Uppercase and Lowercase
characters and based on a character you would like to sort those fields, access
sorting and grouping ignores case sensitivity.
If you would like to get case sensitivity back then simply use
the expression
which will return true (-1) for all
lowercase characters and false for all uppercase characters.
Please note this will only look at the first character of a
string of text.
You can then use this field to group by to split up uppercase
and lowercase words that are the same.
| 