Rs.Open "SELECT * FROM Data WHERE Dia = '" & FindDia & "' and Hei = '" & FindHei & "'", Cn


In the above example how would i modify this so instead of finding the data where " Dia=FindDia" i want it to be able to go say 1 either side.

Example if FindDia was equal to 9 i want it to search for all data that was either 10 , 9 or 8...