By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,921 Members | 1,493 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,921 IT Pros & Developers. It's quick & easy.

Changing The way a field is viewed on Access Report

P: 46
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.
Mar 13 '08 #1
Share this Question
Share on Google+
2 Replies


Expert Mod 2.5K+
P: 2,545
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
Expand|Select|Wrap|Line Numbers
  1. Header
  2. Data... More Data... More Data...
Instead of
Expand|Select|Wrap|Line Numbers
  1. Header
  2. Data
  3. More Data...
  4. More Data...
there is no property you can change that will let you do so. Sorry.

-Stewart
Mar 13 '08 #2

missinglinq
Expert 2.5K+
P: 3,532
Not sure exactly what you're trying to do. I've never used them, but maybe a CrossTab query?

Linq ;0)>
Mar 13 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.