Search MIN and MAX

[Jayhson]

Im only newbie in VB.net i have a code here for my search FORM from my datetimepicker i just wanna add MIN and MAX of mileage WHERE VehicleNo = '2173 Hi Ace' from my code below and the min of milage will be put in textbox1 and the max of mileage will be put in textbox2 can anyone help of my problem

[FONT=Consolas][SIZE=2][COLOR=#008000][FONT=Consolas][SIZE=2][COLOR=#008000][FONT=Consolas][SIZE=2][COLOR=#008000] Me.ExpenditureBindingSource.Filter = (String.Format("Date >= #{0:M/dd/yyyy}# AND Date <= #{1:M/dd/yyyy}#", DateTimePicker1.Value, DateTimePicker2.Value))
[/COLOR][/SIZE][/FONT][/COLOR][/SIZE][/FONT][/COLOR][/SIZE][/FONT]

 

[jmcilhinney]

Someone has already helped you but I'm not sure that anyone is going to give you the code. If you cannot follow simple instructions then it's not really our fault. If this is homework then it would be cheating for us to write your code for you and if you can't follow the instructions already provided then you don't really deserve to get the marks. If this is work then you should take the instructions already provided to one of your co-workers and see if they can help you write the code.

 

[Jayhson]

jmcilhinney: it is not home work.. i wanna try the vb.net.. the problem is no body will help me here in the office because im only one who know about this...