Need help setting up report

[inneedofhelp]

Hello,

I am using access 2002.

I am trying to setup a report that has headings down the left side of the page and then lists the records vertically in columns to the right of it continuously. I have somehow figured out how to get the records to list in columns continuously, but i can not figure out how to make the headings show on every page. Right now they only show on the first page. Thank you in advance. Let me know if more info is needed.

I want my report to look like this.

__________project 1______Project 2.....
heading1____data__________data_
heading2____data__________data

Is there another way I can do this?

 

[Opengrave]

In design view of the report add the field you would like to show on every page to the PAGE HEADER section of the report.

 

[inneedofhelp]

I wish it was that easy...

I want my report to look like this.

__________project 1______Project 2.....
heading1____data__________data_
heading2____data__________data
....

and so on.

The problem i am having is having the headings show on every page. If i put them in the page header they push all of the data below them. Does this explain what i am looking for? Let me know

 

[Opengrave]

I think I understand, this seems like it would be really tough without doing lots of VB code to turn fields on and off based on the length of the string etc... Maybe someone else will come along with an idea. Good luck!

 

[inneedofhelp]

Thank you anyhow... can you think of another way i can do this?

 

[Opengrave]

Not without a better understanding of the data, the existing report design, and exactly what you are trying to get it to look like. I think I sort of understand from the example you gave but can't figure out why the headings only show on the first page.

 

[WayneRyan]

InNeed,

Can't you just put your headings in the Detail section of your
report?

Failing that, make your current report a subreport and you
can have as much room to the left to put whatever you want.

Wayne

 

[inneedofhelp]

That is what i have now. However, my subreport extends horizontally not vertically.

 

[inneedofhelp]

Attached is some example data and report setup.

 

[WayneRyan]

InNeed,

You table structure is making this task more difficult. I quickly
modified them to what is in the enclosure. At least it is
something to discuss, because everytime that you make
a new report or form, you're going to have the same trouble.

Wayne

 

[WayneRyan]

oops,

Should have attached it ...

Wayne

 

[inneedofhelp]

Wayne,

My data does actually come from a few different table. However, i copied the data out of a query i was using into a table to send out.

On the other hand, what were you trying to accomplish with the table structure you set up?


Thanks,

inneedofhelp

 

[WayneRyan]

InNeed,

I should have made a report too. I just wanted to show
that if your data came from tables similar to the
enclosures, it would make your effort a lot easier.

Anytime that you have tables set up with fields
such as Topic1, Topic2, etc. It makes it difficult. In
my example, you would not be facing the trouble with
the "headings" as they are part of your data.

Wayne

 

[inneedofhelp]

Wayne,

i do not see the difference in your tables compared to mine.