Return only certain # of rows?

[BulldogGC]

Using ODBC how would I return say only 5 rows?

[matt_4013]

Well, it depends on which database you're using, but most SQL based ones use the LIMIT parameter.

eg, "SELECT * FROM table WHERE foo='bar' LIMIT 0,5"

[BulldogGC]

MS Access

[BulldogGC]

Someone help me with this?
Using MSAccess how would I only show the 1st 5 results.