Displaying results horizontal

[TopherSD]

I have a report that lists rejected claims along with the reason they were rejected (by group). What I want to do is at the end of each group to have the claim numbers listed in that group appear horizontally as one long string.

From searching the forum I figure I'll need to code this but I know extremely little about coding and could not find in previous post anything that matched exactly what I was trying to do. Any help would be appreciated.

Working with:
Access 2000
1 table "master"
several fields including "claim no", "rej reason", "member name"

 

[stopher]

If I understand correctly you could do this by creating a sub-report and use columns. The main report will show your groupings etc. The sub-report will be used to show your list of claim numbers.

The key point is that when you create your sub-report you need to set the layout to be horizontal:
File=>Page Setup=>Columns

- Enter an appropriate number of columns
- Set the column width so you can just fit your data
- select "across then down" button

The effect using 4 columns will be something like:

[FONT="Courier New"]123 John                    }
124 Jim                     }
125 Bill                    }  Main report
126 Andy                    }
127 Mark                    }
123 124 125 126             } Sub report
127                         }[/FONT]

hth
Chris

 

[TopherSD]

Chris,
Thanx for the reply.

I tried creating a sub-report. Came across two problems. 1st, I am apparently creating it wrong because I am not getting all the results. Using your example I am actually only getting the last number referenced.

123 John }
124 Jim }
125 Bill } Main report
126 Andy }
127 Mark }
127 } Sub report


The bigger issues is that I need this to be a string that I can copy/paste as a whole and put commas between them. The purpose is to be able to take the list and copy the string into another application that will search and pull up the associated images.

Any suggestions?