Results 1 to 2 of 2
  1. #1
    heinensk23 is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2011
    Posts
    13

    Compare fields in table using case sensitive match

    i have 2 different databases that both contain a list of items. The names may be the same, except sometimes the capitalization is the only thing that doesn't match. I need to be able to identify items that are shared across the two systems (tables) but do not have the same capitalization.

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,859
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Case Sensitive Data
    By VLPOTTER in forum Access
    Replies: 1
    Last Post: 04-28-2021, 09:31 AM
  2. Case sensitive login
    By CHEECO in forum Access
    Replies: 7
    Last Post: 02-09-2018, 11:43 AM
  3. Case Sensitive Inner Join
    By Rriemer in forum Queries
    Replies: 3
    Last Post: 10-13-2015, 01:24 PM
  4. Textbox Case Sensitive
    By cbrsix in forum Programming
    Replies: 19
    Last Post: 06-25-2012, 10:52 AM
  5. is access case-sensitive?
    By pen in forum Programming
    Replies: 1
    Last Post: 04-07-2009, 05:13 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums