lower and uppercaps search

[Deleted member 147267]

No it won't, because the expression only finds capital letters. Upper is just an alias name for the calculated field. To get lower case, you'd need a separate query for Between 97 And 122 or you could try Not Between 65 And 90. I think I'd go with the latter since the only characters that can be upper case are letters from A to Z (assuming this is about English). If you specify 97 to 122 (a to z) you'll omit anything where the value might end in something else, assuming that's even possible.

 

[arnelgp]

aside from changing "As [Lower] …"
you also need to change the Where clause:

WHERE (((Asc(Right(Nz(fld2,","),1))) Between 97 And 122));

 

[Deleted member 147267]

Between 97 And 122

Something wrong with the way I said that?
As I said, that will also eliminate anything that might end in a character that's not from a to z, such as %. "Not Between 65 And 90" won't but will eliminate A to Z which is better, IMO.