+ Reply to Thread
Results 1 to 5 of 5

Compare 2 tables with same field names and show records where there are different values?

  1. #1
    Forum Contributor
    Join Date
    05-21-2014
    Location
    United States
    MS-Off Ver
    Office 365 on Windows 10
    Posts
    122

    Question Compare 2 tables with same field names and show records where there are different values?

    I am using Access 2010. I have 2 tables with the same field names where one of the field names is email address.

    What I need to do is compare the 2 tables and show instances where the same field for the same email address are different. It would be ideal if it showed me a side-by-side view showing what the value is in the first table and what the different value is in the other table, and showed multiple differences for the same email address on the same row.

    I tried following the tutorial found at the link below, but it didn't seem to do what I wanted it to do. Anyone have any other tutorials for this?

    https://support.office.com/en-ca/art...f10a5d1cb4#bm2

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Compare 2 tables with same field names and show records where there are different valu

    Create
    Query Design
    Pull in the two tables
    Link them by the their unique key
    Link them also by the email field

    Double click each of the two links, and set them to option 2.

    Run query
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Compare 2 tables with same field names and show records where there are different valu

    I'm terrible at SQL, but here's a more codeybits way.

    Table names: Table1, Table2
    Field Names: ID = Unique Key, Email


    SQL Code attached in file because the forum blocks SQL...
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    05-21-2014
    Location
    United States
    MS-Off Ver
    Office 365 on Windows 10
    Posts
    122

    Question Re: Compare 2 tables with same field names and show records where there are different valu

    Is a unique key (ID) required? My tables do not have this field.

  5. #5
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Compare 2 tables with same field names and show records where there are different valu

    The key can be whatever they have in common.

    Perhaps first and last name are the joins.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pivot Table field show values as % of another value field
    By amotto11 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-27-2015, 04:31 PM
  2. Find duplicate field values and export those records to excel file
    By sirhacksalot in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-12-2013, 10:59 AM
  3. Show query column names behind pivot table field names
    By gbritton in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-18-2013, 03:17 PM
  4. Field names in Pivot Tables
    By ellenhotz in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-13-2013, 09:54 PM
  5. Change an existing field to a calculated field using Show Values as
    By Excel_vba in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-16-2012, 01:50 PM
  6. Replies: 1
    Last Post: 07-23-2012, 12:50 AM
  7. Show records that contain Null Values
    By lanziniad in forum Access Tables & Databases
    Replies: 1
    Last Post: 12-05-2011, 04:45 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1