>>I think what Nadya was getting at was using the report writer to do your grouping.
>>Have a look at the grouping item under the report menu.
>>If your field is called newGroup then simply add a group on newGroup
>>Also in think in your case you want to start a new page when you change group (there is a check box for this)
>>
>>
>>Or you could just do what andrew coates suggested -
>>instead of using the newgroup field, use :
>>int(recno()/10)
>>
>>This will only work if you don't have an index order set on the table.
>>
>>HTH
>>Will
>
>Will,
>
>Thanks a lot for your explanations, making report is much more easier now.
>
>I've tried using newgroup and it worked well but when I tried to use int(recno()/10), the 1st page only contains 9 records and the next pages until EOF() contains 10 records. Could you tell me why this is happend ?
>
>Thanks in advance.
>
>
>Budianto M.

int(1/10)=0
int(2/10)=0
...
int(9/10)=0
int(10/10)=1 && New Group

IOW, int(recno()/10) would not work. I could not create a right formula quickly... NewGroup solution should always work. (if you set it correctly, of course :))

 If it's not broken, fix it until it is.


My Blog