Results 1 to 2 of 2
  1. #1
    AndyOlsenH
    Guest

    Query for Upper Case

    In Access97, how can I query (preferably query design grid criteria cell) a table to return only those field values that contain an uppercase letter? Specifically, a UserName field has individual users in all lower case, but group names contain upper case letters. I need a recordset of group names only. I have tried StrComp, Chr(), Asc(), et al. I think my problem is in comprehending the return of a string vs boolean value, and testing for True/False.

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    352
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Query for Upper Case

    try
    a calculated field asc([UserName])
    Criterion <97

    And untick the output box.
    David Grugeon
    Brisbane Australia

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •