Access query- Filter all CAPS entries


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Access query- Filter all CAPS entries

  1. #1
    Join Date
    Aug 2005
    Posts
    1

    Access query- Filter all CAPS entries

    I have a LastName field with both upper and lower case entries. Some names are entered in all caps (ie DOE) while others are First letter capital letter (ie Doe) Does anyone know of a query that would filter out the all caps entries???
    Thanks in advance for your help!

  2. #2
    Join Date
    Dec 2003
    Posts
    2,750
    Well Access doesn't support case sensitive queries so you're limited to a few options.

    If you're doing a comparison in your SQL statement you can use the StrComp function. However, if you need to check each LastName value then you will have to write a VBA function, which checks each character in order to determine whether the value is all caps, and call this function from your SQL query.
    Paul
    ~~~~
    Microsoft MVP (Visual Basic)

Similar Threads

  1. Call Access Query
    By Mark in forum VB Classic
    Replies: 3
    Last Post: 03-18-2003, 03:25 PM
  2. Query of tablenames in Access 2000
    By Russ in forum VB Classic
    Replies: 5
    Last Post: 02-21-2003, 06:36 PM
  3. Execute a query when apps opens MS Access.
    By James in forum VB Classic
    Replies: 0
    Last Post: 02-11-2001, 04:45 PM
  4. Access query from VB6
    By R2 in forum VB Classic
    Replies: 4
    Last Post: 01-30-2001, 07:50 PM
  5. Count Query, how to access?
    By Marcos in forum ASP.NET
    Replies: 2
    Last Post: 01-23-2001, 12:35 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center