Query To Pull A Sampling Of Data 1

[Swi]

Could someone help me in writing a query to pull the first 10 records, the middle 10 records and the bottom 10 records from a table? Thanks in advance for any help.

Swi

 

[PHV]

What have you tried so far and where in your code are you stuck ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Swi]

This seems to select the first ten rows

SELECT TOP 10 * FROM Test

I am unsure how to go about getting the middle and end sampling though.

Swi

 

[Swi]

After giving it some more thought maybe I could do the following to get the last 10 rows:

SELECT TOP 10 * FROM Test ORDER BY UniqueSeqNum

The problem is what if a unique sequential number is not available?

Swi

 

[dhookom]

If you want the "first" and "last" then you must have a field or fields that describe an order. Records in tables have no order. They are like marbles in a bag.

Duane MS Access MVP

 

[Swi]

Ok, is there any way to just pull a random sampling then?

Swi

 

[dhookom]

Sure, you can pull random records. Check the FAQs of this forum for at least one solution.

Duane MS Access MVP

 

[Swi]

Ok. thanks.

Swi