SQL: "SELECT TOP 6" results entire table

[ClickHere2Surf.com]

I wrote this query:
SELECT TOP 6 * FROM tblProducts ORDER BY FeaturedItem

But it's returning me the entire table rather than the TOP 6 records, I've never had to use TOP before but I'm pretty sure that's the right syntax but it probably isn't.

Also, did they remove the ability to write your own SQL in Access 2003? I onlyfindthose stupid wizards and tables that write the queries for you and can't find where to make and run my own query, this was very easy to find in Access 2000 or XP but I just can't find it anywhere in 2003.

Thanks

[NooNoo]

so this access sql? or another sql server? It makes a difference.

Oh yeah open a query in design view then right click select sqlview

TopValues setting (see help in access) is the thing that uses top n in a select statement. It has some quirks... have a read of the example in help.

[ClickHere2Surf.com]

Yes it is Access SQL

Thanks