select query help

[Guest_imported]

Is there a way to create a query that will select the the first 100 records that start with the letter S in a field. I built one that has thwe criteria S* that returens all the S's but I only want the first 100. Any suggestions? Thanks!

 

[jebry]

Hi!

Make sure the query is sorted the way you want it to be and use the Top keyword:

Select Top 100 UserName From MyTable Order UserName

As an example

hth
Jeff Bridgham
bridgham@purdue.edu

 

[Guest_imported]

Thanks Jeff, where would I type that, I already have S* under the criteria in design view. Would there be a way to have it select the next 100 like 200 to 300? Thanks!

 

[Darkshade]

if you have a "counter" column using autonumber,I would suggest that you count the returned result from your first query and then do another query like

select &quot;the info you want&quot; from &quot;table&quot; where counter <= 100

hope this helped