Jaydeanster wrote: This query returns two rows when I only need a row with the min column... select min(col1ID), col2ID, col3 from tbl where col2ID = 'xxxx' group by col2ID, col3 Your GROUP BY clause causes more than one row to be returned. I am guessing that you want the row with the MIN(col1ID) with the other columns too. So, assuming that each col1ID value is unique then the following should work: SELECT m.col1ID, t.col2ID, t.col3 FROM tbl AS t INNER JOIN (SELECT MIN(col1ID) as col1ID FROM tbl WHERE col2ID = 'xxxx') AS m ON m.col1ID = t.col1ID WHERE col2ID = 'xxxx' Does this help? My: Blog | Photos | Next SQL Presentation WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

Use multiple inner joins ... INNER JOIN Languages as l1 ON t.Language1 = l1.LangID INNER JOIN Languages as l2 ON t.Language2 = l2.LangID INNER JOIN Languages as l3 ON t.Language3 = l3.LangID ...etc. My: Blog | Photos | Next SQL Presentation WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

Have a look at MSDN. Here[^] and Here[^] Hey don't worry, I can handle it. I took something. I can see things no one else can see. Why are you dressed like that? - Jack Burton

dropDown.DataSource = Helpers.GetCountryList ? Of course, you need to write the Helper class as well. Or just create a control. This site probably has one. Christian I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer

It didn't work. :(

i think in that situtaion u cannot use SElect Case, ElseIf more efficent if RadioButton1.Checked then 'Open Form1 dim _frm as new Form1 Form1.ShowDialog ElseIf RadioButton2.Checked then 'Open Form2 ElseIf RadioButton3.Checked then 'Open Form3 Else RadioButton4.Checked then 'Open Form4 End If