MS ACCESS, Compare two similar tables

Discussion in 'General Software' started by Alexander R.A, May 17, 2011.

  1. Alexander R.A

    Alexander R.A

    Joined:
    May 17, 2011
    Messages:
    1
    Likes Received:
    0
    Hi,
    I need to compare to tables where there can be data not 100% identical:

    We have two tables,Table1 and Table2 both with columns Product name and Producer.
    Table 1 is the "master" table.
    The data can be showed in table1 as:
    Product name: AAA
    Producer: GXL

    In table the data can be shown as:
    Product name: AAA or AAA_A or A_AAA
    Producer: GXL

    I need to find all AAA in table2 that exists in table1.

    I have just started to use ACCESS and need someone that can please explain it for me in details:bow:

    THX a lot, best regards Alex
     
    Last edited: May 17, 2011
    Alexander R.A, May 17, 2011
    #1
    1. Advertisements

  2. Alexander R.A

    LynnTroubleshooter

    Joined:
    May 24, 2011
    Messages:
    3
    Likes Received:
    0
    In the second table, make another field (NewField) to store the 3 letter code after stripping off the _A and A_ from the original table (OldField).
    Make an update query to update NewField with the contents of OldField (basically, data backup).
    Make an update query with a calculated field. BeginUnderscore:left([NewField],2) with a criteria of "*_*" In this query, you will update Newfield with a value of right([oldfield],3).
    Make a second update query to check for ending underscores, just reverse the above.
     
    LynnTroubleshooter, May 24, 2011
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Micky

    ACCESS 2007 permissions of linked tables

    Micky, Feb 12, 2009, in forum: General Software
    Replies:
    0
    Views:
    731
    Micky
    Feb 12, 2009
  2. nivrip

    PDF to Word (or similar)

    nivrip, Jan 11, 2010, in forum: General Software
    Replies:
    9
    Views:
    741
    nivrip
    Jan 12, 2010
  3. kellya

    Access 2007 Linked Tables

    kellya, May 13, 2010, in forum: General Software
    Replies:
    0
    Views:
    415
    kellya
    May 13, 2010
  4. carlo67

    is there similar as smart-butler ?

    carlo67, May 23, 2010, in forum: General Software
    Replies:
    0
    Views:
    449
    carlo67
    May 23, 2010
  5. britty21

    Validation between two tables? maybe?

    britty21, Sep 5, 2011, in forum: General Software
    Replies:
    0
    Views:
    682
    britty21
    Sep 5, 2011
Loading...

Share This Page