Report combining data that should not be combined

[Guest]

I have a problem with the Excel reports feature. I have a ticket number and
then multiple lines of text that go with that number. When I generate the
report the number should be displayed with the text associated with it
beneath the number. In the last entry in the report, it is combining the
text of multiple numbers into one big mess. Why is this happening? What can
I do to correct it?

 

[Larry Linson]

I have a problem with the Excel reports feature. I have a ticket number
and
then multiple lines of text that go with that number. When I generate the
report the number should be displayed with the text associated with it
beneath the number. In the last entry in the report, it is combining the
text of multiple numbers into one big mess. Why is this happening? What
can
I do to correct it?

The probability is very high that there's an error in what you've done.
What you can do to correct it is to find the error and fix it. With no more
information about the data you have and how you're using it, I don't think
anyone can be much more specific in helping you. If you'd clarify, that
would greatly improve the chances that you could get useful help here.

My off-the-top-o-me-head guess would be that you are not properly setting
the Sorting and Grouping properties of the Report, if the "one big mess" is
on the Report itself. If it is on the Excel sheet to which you save the
Report, but not on the Report itself, it's probably a different problem.

Larry Linson
Microsoft Access MVP