Report

[mebou]

Hi everyone,



I have a database consisting in plants species and the place where they have been observed. There is a recording for each place where the plants were observed. So when I create a report, regrouping the species, it gives something like:

Name Num_p
FAGR 3
4
BEPO 2
10

What I would like to know is if there is a way to place all my Num_p on the same line for one species separated by a comma to have something like:

Name Num_p
FAGR 3, 4
BEPO 2, 10

Thank you for your help!

[RuralGuy]

Have you looked into Pivot Tables?

[Dinzdale40]

just go into design view of the report and make the text box that is linked to the data you are displaying longer.

edit: just realized it wasn't wrapping text...sry

i would try recreating the report using a different layout. you may be using "stepped" by default.