Changing The way a field is viewed on Access Report

[teneesh]

I have a report where the field ConfType is viewed grouped vertically in a ConfType Header. Now I need to change it so that it is viewed horizontally across the page. How the heck do i do this? I thought maybe i had to change my query and do a join to change how the data is stored, but that sounds far more complicated.

Thanks.

[Stewart Ross]

I have a report where the field ConfType is viewed grouped vertically in a ConfType Header. Now I need to change it so that it is viewed horizontally across the page. How the heck do i do this? I thought maybe i had to change my query and do a join to change how the data is stored, but that sounds far more complicated.

Thanks.

Hi Teneesh. If I am interpreting what you are asking correctly, the short answer is that controls cannot display data from individual rows in a horizontal layout rather than vertical. In other words, if what you want is to see

Header
Data... More Data... More Data...

Instead of

Header
Data
More Data...
More Data...

there is no property you can change that will let you do so. Sorry.

-Stewart

[missinglinq]

Not sure exactly what you're trying to do. I've never used them, but maybe a CrossTab query?

Linq ;0)>