Simple reporting question?

[Chackett]

I need to create a report in access with column headings across the top of the page and row headings along the side - and I need the row headings to be on every page of the report. Is there a feature in access reporting that i am not seeing similar to the excel feature that lets you print cetain columns on each page of the report? Thanks for your help in advance!

 

[Chackett]

nada?

 

[bat17]

View>Page Headers will let you add column headers to each page

Rows repeat with the data so if you add a lable against you text box it will repeat each row.

I am not sure what feature you are refering to in excel, but if it is the column order in page setup then you have a similar function in Access setup.

peter

 

[Royal Presence]

Hi,

I do this alot. You would put what you consider the rows in the detail section. Also take a look at the Sorting and Grouping Feature, which allows a sort function to be developed, similar to excel, but it takes getting used to.

Use the page headers or report header as the last user suggested. That will be your columns.