>>I am doing a report in which I want to list only the first 15 records in each grouping, not the whole file.
>>
>>I put in a counter and asked it to print when the counter is < 16, but it's printing the first 15 then leaving blank lines for all the rest (100's of blank pages). I have the no print when empty checked, but that doesn't do it.
>>
>>Is there a way to get it to quit after 15 and go to the next category?
>>
>>Thanks,
>>Rebecca
>
>Rebecca
>
>
>Try something like:
>
>Select top 15 .... where ... group by ... into cursor csrFifteens
>
>and use the cursor as the currently selected table to feed to the report?
>
>Terry

Thanks, I wondered about that. I just wanted to be lazy and use the whole sorted file. I'll try it.
Rebecca :o))