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

reports: columns in detail only?

P: 2
I am in a conundrum and I am not sure how to do what I want to do.
In short in a report I want either a) everything in one long line or b) only the detail section to be columnar

More detail on the problem...

In a report, I would like the following to occur:

In one line:
Name1, Address1, EventAM, EventPM
Name2, Address2, EventAM, EventPM

The EventAM and EventPM fields are new entries in a table:
A condensed version of the table looks like...

Name | Event# | When
Jacki | Event1 | Morning
Jacki | Event2 | Afternoon
Susan| Event1 | Morning
Susan| Event2 | Afternoon

Now, all I've been able to print in a report is:
where name header is bold, detail is not.

Jacki
Event1, Morning
Event2, Afternoon
Susan
Event1, Morning
Event2, Afternoon

Even this columnar formatting would be acceptable:
Jacki
Event1, Morning Event2, Afternoon
Susan
Event1, Morning Event2, Afternoon

But if I have to do it this way I don't want is for the whole page to be columnar. Just the detail.

Is this even possible? Is my desired output possible?
Oct 14 '06 #1
Share this Question
Share on Google+
3 Replies


Expert 100+
P: 1,221
Sorry, but it's really not clear what you want to ask.

There really does not need to be any relationship between the heading distribution of data and the detail. You can have ...

Name Address 1 Address 2 City State Zip
like that in the heading and

Event 1 AM/PM
Event 2 AM/PM
Event 3 AM/PM
......

in the detail.

I wonder if the problem is that you are letting the report wizard do too much for you? Let the wizard do its thing and then go in to the report in design mode and start moving things around as you like.

If you're still stuck, ask again with a little more detail.

Jim
Oct 15 '06 #2

P: 2
I think you've basically answered my question...

There really does not need to be any relationship between the heading distribution of data and the detail. You can have ...

Name Address 1 Address 2 City State Zip

Event 1 AM/PM
Event 2 AM/PM
Event 3 AM/PM
......
... But what I was getting at was can I columnize the detail part, but not the whole page?

Name Address 1 City State Zip

Event 1 AM/PM Event 2 AM/PM
Event 3 AM/PM ......
.....
Name2 Address 2 Address 2 City State Zip

Event 1 AM/PM Event 2 AM/PM
Event 3 AM/PM ......
.....

Sorry for the confusion.
Oct 15 '06 #3

Expert 100+
P: 1,221
Ah, I think I see what you might find very helpful to know. If you tell Access that you want to sort by various fields, you can also tell Access that you want, optionally, a header and, optionally, a footer, for each thing you sort by.

Each sort field can have it's own set of header/detail/footer, and detail is the only required part.

When I figured that out, I was able to do much more interesting reports.

Jim
Oct 15 '06 #4

Post your reply

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