I have a query with 10,000 records but I only want to see the first 1,000 records...

[Kelvin Beaton]

I have a query with 10,000 records but I only want to see the first 1,000
records

How can I get an Access Querie to only return a specified number of records?

Thanks

Kelvin

 

[Guest]

Add TOP 20 into the SQL statement like this --
SELECT TOP 20

 

[Jeff Boyce]

Kelvin

Define "first"!

Sort them in your query, then use the query properties to get the Top 1000.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Franck]

actually use
Select top 1000
or
Karl thing work but he forgot a parameter
Select top 20 PERCENT
but watch out if you have more than 10000 20% wont be 1000 anymore
so unless the number of records dont change use the percent else the
top 1000

 

[Kelvin Beaton]

thanks that's exactly what I was looking for...

What if I wanted to last X records?

Thanks

Kelvin

 

[Rick Brandt]

thanks that's exactly what I was looking for...

What if I wanted to last X records?

Reverse the sort order.

 

[Rick Brandt]

thanks, I thought of that but had to ask

I'm looking in the MS SQL online book and see there's a statement
"BottomCount" can I use that in Access?

I am unfamiliar with that, but am fairly certain that Access has no such
thing.

 

[Kelvin Beaton]

thanks, I thought of that but had to ask

I'm looking in the MS SQL online book and see there's a statement
"BottomCount" can I use that in Access?

Thanks

Kelvin

 

[Marshall Barton]

I have a query with 10,000 records but I only want to see the first 1,000
records

How can I get an Access Querie to only return a specified number of records?

Use the TOP predicate

SELECT TOP 1000 f1,f2,...
FROM table
ORDER BY somefield