at the moment the database im working with i cannot change the names, so im stuck with names that will not work very well in the WHERE statements and i belive i cannot use alias in WHERE statements either.
(see attached for screen shot of current form)
http://s18.postimage.org/7s4it1srd/form_screenshot_with_code_behind.png[
^]
my goal is:-
a user can input two sizes on the top left hand side of my form,
Across =90
Around =50
these two sizes will then have a range to them i.e. more or less than 5 (next two boxes below them called range)
once i click the search button the 4 boxes on the right will be populated with the upper and lower limits for each size dependent on the range
90 - 5 = 85 (check1.text)
90+ 5 = 95(check2.text)
50 - 5 = 45(check3.text)
50 +5 = 55 (check4.text)
This is so far where i have got to & all is working good.
what i want to do with these 4 numbers is filter my datagridview at the bottom to reflect the users inputs.
what i would like to see happen when i click the search button is
(very bad non coding here - but i want is to filter my datagridview result via a range against Across & Round)
Add to the search button coding maybe,
datagridview1 update( [MM-Across].value is > check1.text but < check2.text AND ALSO [MM-Round].value is > Check3.text but <check4.text),>
im a complete novice to VB & SQL i must admit but im trying to self learn, but im really stuck on this section.
Thank you in advance for any support or help you could offer me,a few projects on here was the closest i can find on the net to what i want to roughly do after 5 hours of looking today)
NaZReD
UK