Retreiving Data from Access

I am trying to return the folling 7 rows form a row picked by the user. Its not working. I am new to SQL and any help is really appreiciated. Thanks in advance. Also, any code samples will really help.

Here is my current statement

Select top 7 * from Rates where Rate = '6'

Your syntax appears correct. Make sure your names are spelt correct and if Rate is not text then remove the single quotes from around it.

like this...

Select top 7 * from Rates where Rate = 6