Displaying results on one line

P

phanda

Hi all,

In a report, is there a way to display results on one line? Here's an
example:

Something......... 2,4,5
Something else......... 1,3,6

I basically want it to display like an index in the back of a book.

The numbers represent the data I want to display in my report. They are
pulled from entries in my table.

Example:

Something 2
Something 4
Something 5
Something else 1
Something else 3
Something else 6
 
M

Marshall Barton

phanda said:
In a report, is there a way to display results on one line? Here's an
example:

Something......... 2,4,5
Something else......... 1,3,6

I basically want it to display like an index in the back of a book.

The numbers represent the data I want to display in my report. They are
pulled from entries in my table.

Example:

Something 2
Something 4
Something 5
Something else 1
Something else 3
Something else 6
Click to expand...


You need to create a function to do that.

Here'a good example of one that I like:
http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'
 
Top