Report with 4 columns (1 query per column)

[Telejazzer]

I'd like to create a report that has 4 columns (One query per column) all in one page.



Please advise on how this can be done.

[June7]

Options:

1. subreports

2. listboxes - although not intended for use on reports they can be utilized in some situations, they don't shrink/grow which means must be sized long enough to display all possible records

[ranman256]

I have 2 reporting tables.
tReportData and tReportFinal

I run a series of queries to append data tReport data in 1 column,
qsPost1 appends to col 1
qsPost2 appends to col 2,
etc.

THEN when all is done, I take ALL the data in tReportData , sum the columns into tReportFinal.
The report runs off tReportFinal.

[June7]

Or as ranman suggests, populate a 'temp' table - table that temporarily holds data for a process. Delete the records when the process completes.