Show first 50 records

[kbrooks]

I can't think of a good way to do this.

I have a query that selects all staff. I would like to change it to 3 or 4 separate queries.....one that shows the 1st through the 50th record, the next that selects the 51st through the 100th record, etc.

Is this possible?

 

[The_Doc_Man]

Syntax exists only for FIRST nnn (which is a keyword you could look up).

To do the others, you need a different approach. You must have some sort of update query and a trash field, perhaps numeric, added to the table in question. Assert a value on the trash field making it equal to the number of records that preceded it in sort order. Then do queries for records between 1 and 50, or between 51 and 100, etc.

I would do the trash field update in VBA because it is easier. But there are ways to do the query you might wish to do. Easier if there are no ties in the sort order.

 

[kbrooks]

Yeah, that's the kicker, I need them in alphabetical order.

Wouldn't be ideal, but I suppose I could list A-K, L-R, S-Z, etc, if I had to. I'd have to play with it and see how to split it equally, I guess.