Columns without repeating the labels every times

[yoshi88]

Hi, I need a report that will show 8 columns side by side. I use the column setting but now the labels are also repeated on every columns. How can I get the labels on the letf side and the columns on the right side without repeating the labels.

This is what I got:

week 1 week 2 week 3 week 4
hours 120 hours 140 hours 110 hours 100
...

And I would like this:
week 1 2 3 4
hours 120 140 110 100
...


Thanks a lot
Frank

 

[67peshawar294]

yoshi,
Click on the labels you don't want and press delete. That should leave your textboxes. Then move your fields to the correct position.

 

[yoshi88]

I cant delete the labels because they are all on one column, I used the multiple column setting but the labels are repeated every time

The report is create like this
LabelWeek FieldWeek
LabelHours FieldHours
...

 

[flaniganmj]

Are you are trying to group on 'Week' and build sideways? I haven't seen it been done with access. Let me know if you figure it out. For the most part, reports are built down. I seen alot reports progress sideways, but never grouped on.

 

[67peshawar294]

yoshi, I will try to dup the info in my db and see. Like flanpk mentioned, haven't seen it done, yet!!!
jim

 

[TomCologne]

Create a Detail Header, cut & paste the labels, that should do it.

You're not alone

TomCologne