listing Line Numbers in a Query

[Stemdriller]

I have a table with hundreds of Sport Clubs entered and their corresponding Leagues they are in. I have to do a mailshot but only 50 at a time.

I have the query setup so it lists all clubs in x League, but cannot limit the query to show only the first 50 or 60 etc etc it only shows all 2000.

I have tried to get the count option going with a bit of successful but just wondered if there was an easier way.

For example is there a way of listing query starting with 1 and the last record takes the 2000 figure but the criteria is >50 or >60 etc??

Anyones help would be appreciated

Thanks
Gareth

 

[jdraw]

I have a table with hundreds of Sport Clubs entered and their corresponding Leagues they are in. I have to do a mailshot but only 50 at a time.

I have the query setup so it lists all clubs in x League, but cannot limit the query to show only the first 50 or 60 etc etc it only shows all 2000.

I have tried to get the count option going with a bit of successful but just wondered if there was an easier way.

For example is there a way of listing query starting with 1 and the last record takes the 2000 figure but the criteria is >50 or >60 etc??

Anyones help would be appreciated

Thanks
Gareth

Please clarify your requirement. Can you show the query you are using?

 

[Stemdriller]

Please clarify your requirement. Can you show the query you are using?

Attached is a snapshot. When run the Query will list anything from 20 -2000. I want the ability to say 'I only want x showing?'

 

[jdraw]

Attached is a snapshot. When run the Query will list anything from 20 -2000. I want the ability to say 'I only want x showing?'

Try this SQL, and see if this is what you're looking for. You can change the 20 to 200 or...

SELECT TOP 20 * FROM tblClubs