Display the First 10 records of a Query/Report only
Chris,
You can use the TOP keyword in the select statement.
SELECT TOP 10 columns FROM table...
Ted McNeal
Quote:
> Hi,
> Can anyone tell me an SQL or Visual Basic code that will
> allow me to display only the first 10 records of a query
> in a report? Let's say the query returns 88 records, but
> I only want to display the first 10 records (yet I don't
> want to run another query to filter the others out).
> There's got to be a way without creating temporary tables,
> etc. right? Can someone lead me in the right direction?
> Is there VB or SQL code I shoule be using? Thanks!
