Sort Order in Access 2002

[Steve]

I have a query which filters records containing uppercase and
Lowercase i.e.

Smith and SMITH, Henderson and HENDERSON etc.

Is there a way that I can filter only those records that contain the
first uppercase letter and the remaining lowercase letters for my
query i.e. Smith , HENDERSON etc.

Thanks

Steve

[Phil Stanton]

Asc(Mid$([SurName],1,1))=Asc(UCase(Mid$([SurName],1,1)))

You can use the Mid$ or Left$ function, but Mid allows you to chexk any
letter

Phil
"Steve" <mu******@hotmail.com> wrote in message
news:3e**************************@posting.google.c om...

I have a query which filters records containing uppercase and
Lowercase i.e.

Smith and SMITH, Henderson and HENDERSON etc.

Is there a way that I can filter only those records that contain the
first uppercase letter and the remaining lowercase letters for my
query i.e. Smith , HENDERSON etc.

Thanks

Steve

[Steve]

Thanks for your reply Phil.

I've tried running the query as an expression but it does not work.
How do I use it on the query grid or elsewhere in Access 2002.

Thanks

Steve
"Phil Stanton" <di********@stantonfamily.co.uk> wrote in message news:<3f***********************@mercury.nildram.ne t>...

Asc(Mid$([SurName],1,1))=Asc(UCase(Mid$([SurName],1,1)))

You can use the Mid$ or Left$ function, but Mid allows you to chexk any
letter

Phil
"Steve" <mu******@hotmail.com> wrote in message
news:3e**************************@posting.google.c om...

I have a query which filters records containing uppercase and
Lowercase i.e.

Smith and SMITH, Henderson and HENDERSON etc.

Is there a way that I can filter only those records that contain the
first uppercase letter and the remaining lowercase letters for my
query i.e. Smith , HENDERSON etc.

Thanks

Steve

[Phil Stanton]

Sorry, not familiar with Access 2002. Only A2K & earlier. I assumed it was
the same.
I am assuming that you create a query based on your table (MyTable), and
still drag the Surname to the top line of the grid. Then the expression
would go in the Criteria of the SurName.

Insidently it will display Smith, SMITH and SmiTH, but not smith. ie it
checks only the first letter

If you can access (sorry for the pun) the SQL of the query you should have
something like

SELECT SurName FROM MyTable WHERE
Asc(Mid$([SurName],1,1))=Asc(UCase(Mid$([SurName],1,1)))

Phil

"Steve" <mu******@hotmail.com> wrote in message
news:3e**************************@posting.google.c om...

Thanks for your reply Phil.

I've tried running the query as an expression but it does not work.
How do I use it on the query grid or elsewhere in Access 2002.

Thanks

Steve
"Phil Stanton" <di********@stantonfamily.co.uk> wrote in message

news:<3f***********************@mercury.nildram.ne t>...

Asc(Mid$([SurName],1,1))=Asc(UCase(Mid$([SurName],1,1)))

You can use the Mid$ or Left$ function, but Mid allows you to chexk any
letter

Phil
"Steve" <mu******@hotmail.com> wrote in message
news:3e**************************@posting.google.c om...

I have a query which filters records containing uppercase and
Lowercase i.e.

Smith and SMITH, Henderson and HENDERSON etc.

Is there a way that I can filter only those records that contain the
first uppercase letter and the remaining lowercase letters for my
query i.e. Smith , HENDERSON etc.

Thanks

Steve