Sub-Report (1 Viewer)

[Peter Paul]

I have a sub-report which can include several entries for the main report. The entries are short codes, and I would like to have them display horizontally across the report, rather than vertically like Access would like. Any ideas on how I can do this?

Any help would be much appreciated,

Peter Paul

 

[lnoles]

I would add another column in the query for the sub-report and concatenate the results of the other columns into that field. Then uncheck the other fields so that the new one is the only one that shows on the report.

 

[Pat Hartman]

You might try basing the subreport on a crosstab query.