Results 1 to 2 of 2
  1. #1
    DB2010MN26 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Sep 2010
    Posts
    37

    Data validation query that compares only first 15 characters of fields in table


    I Have two tables: OS_NAME and DS_NAME, I want to compare two fields in each table to look for differences ("NAME" field on OS_NAME, and "FT_T_ISD" on DS_NAME). I only want it to compare the first 15 characters of each field, how would I accomplish this?

  2. #2
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    Following query gets names from the two tables for those names are not same but first 15 chars are same:
    select os_name.name,ds_name.ds_name from os_name inner join ds_name on left(os_name.name,15)=left(ds_name.ds_name,15) where os_name.name <> ds_name.ds_name

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

Similar Threads

  1. Replies: 2
    Last Post: 10-23-2010, 09:38 AM
  2. Replies: 7
    Last Post: 11-22-2009, 02:38 PM
  3. Parsing for data in between two characters
    By rawdata in forum Access
    Replies: 7
    Last Post: 11-02-2009, 04:46 AM
  4. Replies: 4
    Last Post: 06-10-2009, 12:43 PM
  5. Referencing table data in field validation rule
    By toad848 in forum Database Design
    Replies: 3
    Last Post: 03-19-2009, 07:03 AM

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