Trouble With 'TOP' Statement

Background:

I am using standard ASP to connect and select records from a SQL Server 2000 database. My goal is to select the 3 most recent records that match my criteria.

Problem: When I run my query and display the records without the 'TOP 3' statment all records matching my criteria are predictably returned. However, when I add the 'Top 3' statement only one record is returned.

Here is the SQL code I am using to select my records:


Code:

strSql = "SELECT TOP 3 GroupImageName, groupImageDate "
strSql= strSql & "FROM groupImages "
strSql= strSql & "WHERE groups_id='" & groups_id & "' "
strSql= strSql & "ORDER BY groupImageDate"

set rs=conn.execute(strSql)



and here is the code I use to display the records. There isn't any formatting yet as I am attempting to get the expected results before adding any formatting to the page:


Code:

if not rs.eof then
do while not rs.eof
response.Write(rs("GroupImageName"))
rs.movenext
loop
end if



Even if I remove the 'ORDER BY' statment I am still only seeing 1 record. If I remove the 'top 3' statement 9 records are returned!

Any help would be appreciated. Thanks.