>>Did you make it to work?
>
>Hi Naomi -
>No I have not been able to make it work with a single select. :(
>Your idea is actually very similar to the samples shown for the pagination in the article recommended by Mike. When modified to my specific case they pretty much become the same. The problem seems to be the UNION clause.

I haven't yet read that article. Check today's thread
Re: How to use SQL Select UNION with TOP Thread #1303352 for two proposed solutions, perhaps you can adapt them for your case.