lowercase code query problems

[Helpexcel167]

Hey guys,

I have the following codes in a database but some of them have been inputted lowercase and not in uppercase, so wondering how do I make a query to display only rows where the codes are lowercase?

Help with example code would be appreciated.

 

[welshgasman]

Crossposted

Trying to make a query to pick out lowercase codes

Hey guys, I have the following codes in a database but some of them have been inputted lowercase and not in uppercase, so wondering how do I make a query to display only rows where the codes are lowercase? Help with example code would be appreciated.

www.access-programmers.co.uk

Lowercase query sort problems

Hey guys, I have a set of codes in a database but some of them have been inputted lowercase and not in uppercase, so wondering how do I make a query to display only rows where the codes are lowercase? Help with example code would be appreciated.

www.accessforums.net

 

[Joe4]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.