grouping in reports in access

[goldwhispers]

I am looking for claims that have similar information that might indicate duplicates.

When i do the query, the results are in one line from both
Is there a way of displaying the lines one under the other

so say for example i have this in my result

provider1, amountpaid1, uniquenumber1, provider2, amountpaid2, uniquenumber2

how can i get them do be displayed like this

provider1, amountpaid1, uniquenumber1
provider2, amountpaid2, uniquenumber2

Thing is grouping levels only go up to about 4, i could use that but i need more grouping levels, anyone know how they work outside of the wizard?

is there a way of doing this?

 

[PaulBricker]

Open the report in Design View. On the menu bar go to View...Sorting and Grouping. This will open the sorting and grouping box. This will give you a lot more groups and more control over what you can do with them.

Paul

 

[dhookom]

If "provider1, amountpaid1, uniquenumber1, provider2, amountpaid2, uniquenumber2" are the text boxes, then just move half of them under the other half.

Duane
MS Access MVP