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

group header changes in snaking report

P: 6
In Access 2003 reports, I have a multi-column report. The reports lists names and addresses. The data is grouped by the first letter of the last name. If the letter changes in the middle of a column, the next 'group' starts at the top of the next column instead of just continuing down the page.

What I want is

A

Abbot
Adams
...
Akins

B

Baker
Bell
...
Brown

What I'm getting is

A

Abbot
Adams
...
Akins

then the 'B's begin at the top of the next column no matter how far down the previous column the 'A's ended.

Does anyone have any suggestions?
Aug 16 '08 #1
Share this Question
Share on Google+
4 Replies


100+
P: 167
[HTML]Click Sorting/Grouping button on the report design toolbar
Set Keep together property to "No" (currently it's set to "Whole group")[/HTML]
Aug 19 '08 #2

P: 6
Thanks for the answer! I checked that and it is set to 'No'. When the report was still a single column report, I didn't have the problem. Do you have any other idea what might be causing it? Thanks.
Aug 20 '08 #3

100+
P: 167
I reproduced the same result using some test data.
I've posted the solution in my first post.

Maybe you could make a new test report and try to get the results you wanted.
Than compare your original report with test report to find the difference...
Aug 20 '08 #4

P: 6
Thank you. I can't reproduce my error with other reports. I also created a new one and couldn't reproduce the error. I can't find out what's different about this report yet, but I'll keep looking. Thanks for the advice.
Aug 23 '08 #5

Post your reply

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