Report format

[Guest]

Hi

Is it possible to format the report to show the data in the following
way(landscape)

Month :June July
==== ==== ====
Item Qty Qty
------ ----- ----
Item1 5 7
Item2 4 9
Item3 10 25

now in my report it shows one after another, i.e. month june and it's qty
first under that July. I have tried it in grouping and sorting, but did not
work. Please advise.

Thanks

 

[David W]

Make a Crosstab Query and use it for the recordsoucre of the report.