Results 1 to 2 of 2
  1. #1
    BigBig5 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2014
    Posts
    7

    Exclamation Unmatching 2 queries comes out BLANK

    I am trying to unmatch two queries and it keeps coming out blank.

    Code:
    SELECT [~Matching PhoneNumbers RealUsers-AD View].UserName, [~Matching PhoneNumbers RealUsers-AD View].LastName, [~Matching PhoneNumbers RealUsers-AD View].FirstName, [~Matching PhoneNumbers RealUsers-AD View].Department, [~Matching PhoneNumbers RealUsers-AD View].AD_Phone
    FROM [~Matching PhoneNumbers RealUsers-AD View] LEFT JOIN [~Matching PhoneNumbers RealUsers-WebView] ON ([~Matching PhoneNumbers RealUsers-AD View].AD_Phone = [~Matching PhoneNumbers RealUsers-WebView].AD_Phone) AND ([~Matching PhoneNumbers RealUsers-AD View].Web_Phone = [~Matching PhoneNumbers RealUsers-WebView].Web_Phone)
    WHERE ((([~Matching PhoneNumbers RealUsers-WebView].Web_Phone) Is Null));


  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    When I look at the sql , nothing is jumping out at me. Should function. Perhaps everything matches.

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

Similar Threads

  1. Replies: 17
    Last Post: 08-27-2013, 10:21 PM
  2. Replies: 7
    Last Post: 09-06-2012, 06:04 AM
  3. Replies: 1
    Last Post: 07-25-2011, 09:57 AM
  4. Last matched item in an unmatching query
    By kabaa01 in forum Queries
    Replies: 0
    Last Post: 05-19-2010, 03:46 PM
  5. Replies: 5
    Last Post: 03-20-2010, 08:30 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