Displaying results on one line

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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'
 
Back
Top