Display First N records

[Radtastic10]

I have a query where I only need to display the 5 or 10 latest records. I haven't been able to find anything that works.

I have the results displaying in descending order which is helpful and will suffice, but don't really need all the additional information. I would just like to display just the amount of records that we decide is best for us.

Not sure how to set up the query either in design view or the actual SQL in order to get the desired result.

[pbaldy]

SELECT TOP 5 Field1...

[Radtastic10]

Just so I make sure I understand this correctly:

SELECT TOP 5 table1.[field1]
FROM table1
ORDER BY table1.[field1] DESC;

Is that the correct code?

[pbaldy]

That is syntactically correct, yes.