Search results

What's the difference between lcase and ucase and how do I pick out lowercase codes from a column query.

The picture is what the codes are meant to look like bur they don't as some been inputted wrong

I'm rather stuck as all suggestions tried so far isn't working

The goal from the original post was to get the code column in a query to pick up any codes which are lowercase and have been incorrectly added and display then in a query

Basically I have one table with multiple tables within it and I am trying to query it and want to add some criteria to the code column to pick out the lowercase codes and then manually fix them myself just incase some are correct

Plus I want it to tell me the code problems so I can manually fix them from the table drop down

I don't want to use SQL code I want it to be picked up from a access query

There isn't a code to change them as it is manually done I just need a query to pick out the lowercase codes for now

I don't want them automatically changed as not sure what table they are from so want the query to tell me what table they are from also

Thought u could just use come criteria in a column due to the main table the query uses has all the tables linked into one

How would that work

Can't u sort a column by upper or lower case

No I need to make a query to list them as the query will be searching multiple tables at once picking up the ones with lowercase. How do I make it pick up the lowercase ones

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.