Show first 50 records using VBA

**LilyMarie** · 06-13-2009, 08:34 AM

Hi all,

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?

**ConneXionLost** · 06-14-2009, 02:17 AM

Hi LilyMarie,

Not a complete answer for you. Switch your query to SQL view and change it from:

SELECT ...

to:

SELECT TOP 50 ...

This will give you the first 50 records.

- - - -

Beyond that you'll need to select the staff by their IDs or build a sort column in the staff table.

Cheers,