Add a label to the left side muliple column report 1

[mchester]

I have a five column report. I to label the rows down the left side. When I do it access puts the label in every column. I need one label and five colums of rows.

Thanks
mike

 

[ineuw]

The only way you can achieve what you want is to use an unbound text box, (instead of a label), on the left of the data column with the ControlSource property as ="Label caption". Then select the Hide duplicates property.

However, using group or page header is a better option for column headers.

 

[SilentAiche]

mchester,

Welcome to Tek-Tips!

Although it looks like ineuw has already helped solve your problem, I wanted to mention one thing for future Report/Access issues you may have.

Tek-Tips has a seperate [blue]Microsoft: Access Reports[/blue] forum ([blue]Forum703[/blue]) that would have been a better place to post this particular question.

One of the cool things about Tek-Tips is you can post a question and get several workable solutions. Then you can choose the fix that best suits your experience, skills, or what you're simply most comfortable with. I actually participate in five different Access forums (Forms, Queries, Reports, Tables/Relationships, and Other). Posting to the right forum increases the odds of receiving multiple solutions.

Good luck!
Tim

[blue]_____________________________________________________
If you need immediate assistance, please raise your hand.
If you are outside of Raleigh, raise your hand and say[/blue] [red]Ooh! Ooh![/red]

 

[dhookom]

mchester,
If I understand correctly, you might find the solution in this KB article

http://support.microsoft.com/default.aspx?scid=kb;en-us;210044&Product=acc.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]