Results 1 to 2 of 2
  1. 05-23-2014, 10:00 AM #1
    BigBig5
    BigBig5 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2014
    Posts
    7

    Question How to Find Mismatch of two fields in One Query?


    I have a query that has two phone number fields and want to find the mismatch phone numbers. How can I do that?
    Reply With Quote Reply With Quote
  2. 05-23-2014, 10:04 AM #2
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    Have you looked at the unmatched query wizard?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Loop Subform to find null fields
    By rdkelly3 in forum Forms
    Replies: 2
    Last Post: 01-12-2014, 08:39 AM
  2. Mismatch between fields in heading section and fields in detail secion
    By Mary K Levie in forum Reports
    Replies: 1
    Last Post: 02-24-2012, 12:36 PM
  3. Query to find and COMBINE rows based on 2 fields
    By admessing in forum Queries
    Replies: 2
    Last Post: 12-13-2011, 12:59 PM
  4. Using if to find blank fields?
    By newtoAccess in forum Queries
    Replies: 4
    Last Post: 03-20-2011, 10:48 AM
  5. Add fields and find percentage
    By gurp99 in forum Queries
    Replies: 1
    Last Post: 08-09-2010, 03:57 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums