Separate grouped records by (let’s say) a coma instead of a line

[florent prunier]

Hello,

Here is a little problem of mine that no one around me can answer (a
recurrent problem!). Imagine a very simple case study where I work on two
fields, let’s say: <Species> and <Locality>.

I want to report the results of a study (an inventory) so that I create a
straightforward report. With the sorting and grouping facilities this could
give easily this:
Species 1
Locality 1
Locality 2
Locality 3
Species 2
etc.

So far, so good: all my information is correctly sorted. Unfortunately this
solution combining just few hundreds <Species> and few dozens <Localities>
takes thousand of lines! It soon becomes rather tedious to read and not
synthetic at all. Presenting a cross table is not very effective either
because there are enough localities for the number of columns is unbearable.

What I need is the following:
Species 1
123
Species 2
1

Or even better:
Species 1 1,2,3
Species 2 1

Is there anyone who know how to separate grouped records by (let’s say) a
coma instead of a line.

Thank you very much indeed.

 

[John Spencer]

See Duane Hookom's Concatenate() function at :

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

That should do what you want.

Another method would be to use a multicolumn subreport to return the
localities for each species.
So you would have a record source for the main report that included only the
Species information (Distinct)
The subreport would contain the Species and Locality. Set the subreport up
to do multi columns across then down.