How to display one Record per Report's page? 1

[Katya85S]

In Access report I use Groupping by OrderID. Each Order might have few items. So Items are displayed in the Detail part of the OrderID Group.

The report's recordsource is a query:

SELECT OrderID, OrderDate, OrdererName, ItemName, ItemQuantity FROM tblOrder inner join tblItem on tblOrder.OrderID=tblItem.OrderID

I need each Order with all related to this Order information to be displayed on every separate page, so next order - next page. Is it possible?
So far next Order fallows previouse order on the same page, and some of orders are displayed: first part of it on one page, another part of it on next page.

Thank you all in advance.

 

[hymn]

have a look at

http://support.microsoft.com/?kbid=314628

Hope this helps
Hymn

 

[Katya85S]

Greate tip!
Thank you very much Hymn!

 

[hymn]

pleasure

Hope this helps
Hymn

 

[Katya85S]

It does. With 'Forth Next Page' and 'Keep Together' properties I've managed the report the way user wants to see it.
Thanks again.