Limit record returns from data base 2

[DK47]

Hey All,
Using Jet4 with an Access database, would it be possible to limit the number of records returned, using the RecordCount Property in an SQL statement?
For example, if an SQL query called for values associated with dates, could it be written to return just 5 or 10 records?

Thanks in advance.
Dwight

 

[MarkSweetland]

Access 2002, SQL Server can use TOP n in the select ..

SELECT TOP 5 <column1>, ... from


Mark

&quot;You guys pair up in groups of three, then line up in a circle.&quot;
- Bill Peterson, a Florida State football coach

 

[Swi]

SELECT TOP 5 * FROM database

The top 5 indicator would mean to take the top 5 records
that matched the criteria.

Swi

 

[DK47]

Thanks Guys,
That will do the trick.
Have a great day.
Dwight

 

[DK47]

Mark and Swi,
An additional question on this, if you don't mind.

How would I get the last 10 records from the table, instead of the first 10.

I tried to use the ASC and DESC keywords but this only succeeded in rearranging the order of the first 10 and did not call the last entries in the table.

Thanks,
Dwight

 

[vb5prgrmr]

[tt]
Select Top 10 From Table Where Criteria = input Order By Unique ID Autonumber desc
[/tt]

Or something like that...

Good Luck