Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

Katya85S

Programmer
Joined
Jul 19, 2004
Messages
190
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.

 
Greate tip!
Thank you very much Hymn!
 
pleasure

Hope this helps
Hymn
 
It does. With 'Forth Next Page' and 'Keep Together' properties I've managed the report the way user wants to see it.
Thanks again. :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top