How do I display only the first few records in a recordset. I don't
want paging. I just want to list the last few additions to a database
and thats it. Is there a simple way?
ryangrayson@gmail.com wrote:
> How do I display only the first few records in a recordset. I don't
> want paging. I just want to list the last few additions to a database
> and thats it. Is there a simple way?
SELECT TOP n ORDER BY
The first n is the number of records you want to select.
field that defines the order in which the records appear - usually an
incremented ID field.
--
Mike Brind