Vælg de to nærmeste records på den aktuelle

Du kan gøre sådan her:
WHERE IDproduct > x ORDER BY IDproduct LIMIT 1
WHERE IDproduct < x ORDER BY IDproduct DESC LIMIT 1

jeg endte med at lave 3 recordsets for at få vist det i den rigtige rækkefølge, men det er lidt ala det du foreslår:

rsRelatedLess.Source = "SELECT * FROM becausetest.products WHERE Active = 'Y' AND IDproduct < " & rsSpecific("IDproduct") & " AND productcategoryID = " & rsSpecific("productcategoryID") & " ORDER BY IDproduct DESC"
rsRelatedLess.CursorType = 0

rsRelatedLess2.Source = "SELECT * FROM becausetest.products WHERE Active = 'Y' AND IDproduct < " & rsRelatedLess("IDproduct") & " AND productcategoryID = " & rsSpecific("productcategoryID") & " ORDER BY IDproduct DESC"
rsRelatedMore.Source = "SELECT * FROM becausetest.products WHERE Active = 'Y' AND IDproduct > " & rsSpecific("IDproduct") & " AND productcategoryID = " & rsSpecific("productcategoryID")

vil du have point ?

Svar.