Unable to get a report grouped.

[naiku]

I have a report that I created and am having trouble grouping the data. The report is for an order, where at the top are details for the order (supplier name, delivery address etc) and then underneath are listed all of the items on that delivery.

However, I only get 1 item (when I know I should have 4 from the test data that I put into the database tables). I have looked at the grouping data, and have it grouped by supplier ID.

In the supplier header I have all the information relating to the details above, and then on the main section of the report I have item details.

Thanks.

 

[Crowley16]

check the underlying query for the report, see if it's pulling out the correct records...

from what you've said, you should have 4 rows of data all with the same supplier id...

--------------------
Procrastinate Now!

 

[naiku]

Thanks for the reply, I already checked the query though and do get 4 rows of data. This is why I am confused with why my report only shows 1 row.

 

[dhookom]

Are you placing your data controls in your detail section?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]