simple question (hopefully)

[hrov]

I have a fairly simple list in a report of about 80 rows.

How can i group these rows? As in the first 10 are in "group 1". The second group are in "group 2" etc.

 

[Matoco1]

How have you got the report linked? from a table or query? If you have linked to a query you can group them in the query in the sort field.

 

[hrov]

How have you got the report linked? from a table or query? If you have linked to a query you can group them in the query in the sort field.

Either i dont understand what you mean or i explained myself wrong:

I know that i can sort my query (ascending etc) but how do i group it?

here is what i want my report to do (if i wanted to group every 5 customers)>>

customer A 1
Customer B 1
Customer C 1
Customer D 1
Customer E 1

Customer F 2
Customer G 2
Customer H 2

etc
e.g. what i want is to designated the number 1 to the first five. Number 2 to the second five. Number 3 to the third five. The data is already sorted how i want, i just need to group it by designating the numbers in 5's.................

 

[hrov]

Can anyone help?

The report is sorted correctly, now i just want to give a nmber 1 to the first 5 rows, a number 2 to the rows 5-10 etc.