Create different report page

[syedadnan]

Regards,

Me having a DB and a report is there from query now what i want is ;

if query fields are apple, bat, cat, dog, elephant and i want in report the first three fields like apple, bat, cat to be displayed at first page then remaining on next and so on. whereas i have a proper report header and footer which i donot want to change for any page means will remain same for all pages.. any idea please..:banghead:

 

[Drunkenneo]

It seems u need column to eaxtract in alphabetical order, query and add order by column name asc,

If you provide the header and footer to your report it will b came through out the page when navigated.

 

[syedadnan]

Thanks for the reply dear, but still it is uncleared to me as me very new to phase

 

[Drunkenneo]

First Say Q is the query you want to make from Table T
the code for the query as you mentioned for Q will BE
SELECT * FROM T ORDER BY [column_animName] asc

While report of a query, Use query Wizard which you will find on create Ribbon and give reference of query Q, which will populate the Report as per your requirement.

For title in the Report Header section of the Access Report. By default, the Report Header only displays on the first page of the report, not on the subsequent pages.

To set up a title that appears on every page, it is easiest to move your title to the Page Header section of the report.

To do this, open your report in design view.