I Have Table Like this :- Car_Num , Job_Num , Current_dist , prev_dist , Oil_type , Value , Change_date
1254 , 1 , 5000 , 4000 , type1 , 500 , 1-9-2014
1254 , 2 , 5500 , 5000 , type3 , 300 , 1-12-2014
1254 , 3 , 6100 , 5500 , type2 , 200 , 15-3-2015
How i select data when last distance for this car_Number = 1254 is 5000 kilo ,How i make loop to select this car in crystal report in C# WinApp