making report with two columns (detail section)

[mazemi]

Hi dears.
I want to make a monthly sales report for each year from two tables. I need to print this report with two columns, Left column for odd number months and right column for even number months in the detail section of the report.


Unfortunately page setup does not help me!

Any solution will be appreciated.

[ranman256]

query :
select [NAME], Odd: Iif(month(MyDate)) mod 2)>0,[VALUE],0), Even: Iif(month(MyDate)) mod 2)=0,[VALUE],0) from table

[mazemi]

tanks moke123.
The problem is solved by using sub report.