Show first 50 records using VBA

LilyMarie · #1 06-13-2009, 07: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 · #2 06-14-2009, 01: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,

LilyMarie · #3 06-15-2009, 07:13 AM

Thanks for your reply but i need the programmatic solution.So that i can solve my problem.

Welcome to the Excel Forum

Forum Statistics