Hi,

I have table with 5 columns - one of which is Last Name - and I need
to pull all last names that are in lowercase. The table has 10,000
records and the last name field should look like SMITH, but some of
the records are listed as smith. What query can I run in access on the
LAST NAME field to pull only records where the LAST NAME = lowercase.

Hi Joe_G,

You can create a query for this

Select LastName, LCase(LaseName) as LCLaseName, Strcomp(LastName, LCLaseName,
0) as CompareWord From [Table]

After that you create 1 query to filter the above query where CompareWord  =
0. this will allow to display all the name with LowerCase

joe_G wrote:
>Hi,
>
>I have table with 5 columns - one of which is Last Name - and I need
>to pull all last names that are in lowercase. The table has 10,000
>records and the last name field should look like SMITH, but some of
>the records are listed as smith. What query can I run in access on the
>LAST NAME field to pull only records where the LAST NAME = lowercase.

-- 
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200911/1

Or just run an update query to change every LastName to ALL upper case

UPDATE [YourTable]
SET LastName = UCase(LastName)
WHERE LastName is Not Null


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Benjamins via AccessMonster.com wrote:
> Hi Joe_G,
> 
> You can create a query for this
> 
> Select LastName, LCase(LaseName) as LCLaseName, Strcomp(LastName, LCLaseName,
> 0) as CompareWord From [Table]
> 
> After that you create 1 query to filter the above query where CompareWord  =
> 0. this will allow to display all the name with LowerCase
> 
> joe_G wrote:
>> Hi,
>>
>> I have table with 5 columns - one of which is Last Name - and I need
>> to pull all last names that are in lowercase. The table has 10,000
>> records and the last name field should look like SMITH, but some of
>> the records are listed as smith. What query can I run in access on the
>> LAST NAME field to pull only records where the LAST NAME = lowercase.
> 

On Nov 25, 8:29=A0am, John Spencer <spen...@chpdm.edu> wrote:
> Or just run an update query to change every LastName to ALL upper case
>
> UPDATE [YourTable]
> SET LastName =3D UCase(LastName)
> WHERE LastName is Not Null
>
> John Spencer
> Access MVP 2002-2005, 2007-2009
> The Hilltop Institute
> University of Maryland Baltimore County
>
>
>
> Benjamins via AccessMonster.com wrote:
> > Hi Joe_G,
>
> > You can create a query for this
>
> > Select LastName, LCase(LaseName) as LCLaseName, Strcomp(LastName, LCLas=
eName,
> > 0) as CompareWord From [Table]
>
> > After that you create 1 query to filter the above query where CompareWo=
rd =A0=3D
> > 0. this will allow to display all the name with LowerCase
>
> > joe_G wrote:
> >> Hi,
>
> >> I have table with 5 columns - one of which is Last Name - and I need
> >> to pull all last names that are in lowercase. The table has 10,000
> >> records and the last name field should look like SMITH, but some of
> >> the records are listed as smith. What query can I run in access on the
> >> LAST NAME field to pull only records where the LAST NAME =3D lowercase=
..- Hide quoted text -
>
> - Show quoted text -

Hi,

Thank you for the reply; I will try these options out

thanks,