Results 1 to 2 of 2
  1. #1
    cutsygurl is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2013
    Posts
    1

    Trouble finding closest match


    I'm trying to find the closest match but it gives me all the ones that match. I'm using access 2010.

    SELECT [dbo_test log].[Cabinet S/N], Right([dbo_test log]![Cabinet S/N],3) AS Num, IIf(Right([dbo_test log]![Cabinet S/N],3)<[Ending_Machine_Num]![Ending_Num],[Ending_Machine_Num]![Ending_Num]) AS Closest_Match, Ending_Machine_Num.shipping_date
    FROM [dbo_test log] LEFT JOIN Ending_Machine_Num ON [dbo_test log].[Machine Type] = Ending_Machine_Num.[Machine Type]
    WHERE ((([dbo_test log].Finish)=False)) and abs([ending_num]- Right([dbo_test log]![Cabinet S/N],3));

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Can you define closest match? Some examples would be helpful. You have not provided enough information for a suggested solution.

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

Similar Threads

  1. Trouble Finding "Oldest" Data
    By bigdan5428 in forum Access
    Replies: 5
    Last Post: 04-26-2012, 05:25 PM
  2. Replies: 16
    Last Post: 03-13-2012, 03:47 PM
  3. find the closest year
    By 12345678 in forum Queries
    Replies: 1
    Last Post: 05-25-2011, 05:07 AM
  4. Match and Consolidate
    By Yap in forum Access
    Replies: 3
    Last Post: 12-16-2010, 04:26 PM
  5. Finding data that doesn't match
    By dlhayes in forum Queries
    Replies: 1
    Last Post: 11-11-2006, 08:14 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
  •  
Other Forums: Microsoft Office Forums