Distinguish Cap Letters and Lowercase letters

M

MCyn

I have a table consisting of letters and the state that letter represents.
Now I'm trying to build a query that brings in this table but I keep getting
double the data because it sees a letter twice and brings in the two states
it recognizes it as.

Example. My table would read (a = TX and A = CA) when I run my query it
reads both A's and brings in the capitalized "A" and lowercase "a" together
with the states. How do I distinguish the two and only bring in the lowercase
letters with their respected states?
 
K

Ken Snell [MVP]

A is Chr(65). a is Chr(97). You can use this to differentiate between them.
 
D

Dennis

There is probably a better way but you can add a hidden column in the query
NumStat: Asc([StateCode])
In the criteria for this column, put 97
 
Top