case sensitive query

[s0ccerdude]

I understand that queries in Access are case insensitive by default. Is there a way to change this so that a query becomes case sensitive? I want to sort out all of the records with "apple" but want to keep those with "Apple".
Can anyone provide an easy answer?

 

[Blorf]

Try using something like this (I know there is a better way, but this is what I got)

Filter:Asc(left([YourField],2))

and for Criter, use

>=97 and <=122

ChaZ

Ascii dumb question, get a dumb Ansi