Two Detail sections

[james28]

Hello All!

I have an issue, that I think I have an answer to, but I was hoping that someone with more experience may be able to confirm if I am heading down the correct path or if I am wasting time.





I have two very different queries that do not overlap in columns at all.

I would like to have two detail sections on my report. The first would list all of the results of query 1, in a list. Immediately after that, I would have another list, this time with all of the results from query 2.

From what I can tell in my research, it is not possible to add a second detail area. Is this correct?


If it is not possible to add a second detail section, is a sub report the best way to proceed?



Thank you in advanced!

[pbaldy]

Correct, you can't have two detail sections. Subreports are an option, as is a UNION query to combine the two queries.