How to Summarize a Report?

[Mr Key]

Hi all!
Once again I found myself in position to ask for your help!
I have a report Originated from query which shows the sales details as follows:

ProdID  ProductName  Quantity  Price  TotalSell Month 
   1    JZ            4        50$   200$       Jan
   2    Mbu           56       2$    112$       Jan
   3    Maiz          50       1.5$  75$        Jan
   4    Rice          500      1$    500$       Jan
   5    Bity          400      4$    1600$      Jan
   6    JJ            12       1$    12$        Jan
   7    Pop           45       2$    90$        Feb
   8    Put           33       1$    33$        Jan   
   9    JZ            4        50$   200$       Feb
   10   Mbu           56       2$    112$       Feb
   11   Maiz          50       1.5$  75$        Feb
   12   Rice          50       1$    50$        Feb
   13   Bity          40       4$    160$       Feb
   14   JJ            12       1$    12$        Feb
   15   Pop           45       2$    90$        March
   16   Put           33       1$    33$        Feb
   17   JZ            4        50$   200$       March
   18   Mbu           56       2$    112$       March
   19   Maiz          50       1.5$  75$        March
   20   Rice          500      1$    500$       March
   21   Bity          400      4$    1600$      March
   22   JJ            12       1$    12$        March
   23   Pop           45       2$    90$        Apr
   24   Put           33       1$    33$        March  
   25   JZ            4        50$   200$       Apr
   26   Mbu           56       2$    112$       Apr
   27   Maiz          50       1.5$  75$        Apr
   28   Rice          50       1$    50$        Apr
   29   Bity          40       4$    160$       Apr
   30   JJ            12       1$    12$        Apr
   31   Pop           45       2$    90$        May
   32   Put           33       1$    33$        Apr
   33   JZ            4        50$   200$       May
   34   Mbu           56       2$    112$       May
   35   Maiz          50       1.5$  75$        May
   36   Rice          500      1$    500$       May
   37   Bity          400      4$    1600$      May
   38   JJ            12       1$    12$        May
   39   Pop           45       2$    90$        May
   40   Put           33       1$    33$        June 
   41   JZ            4        50$   200$       June
   42   Mbu           56       2$    112$       June
   43   Maiz          50       1.5$  75$        June
   44   Rice          50       1$    50$        June
   45   Bity          40       4$    160$       June
   46   JJ            12       1$    12$        June
   47   Pop           45       2$    90$        June
   48   Put           33       1$    33$        June 
 

I want this report to be summarized by month as follows

Month Jan                                       Month Feb                                             .........
ProdID ProductName Quantity Price TotalSell     ProdID  ProductName Quantity  Price  TotalSell 
   1    JZ            4        50$   200$           7    Pop           45       2$    90$        
   2    Mbu           56       2$    112$           9    JZ            4        50$   200$      
   3    Maiz          50       1.5$  75$            10   Mbu           56       2$    112$        
   4    Rice          500      1$    500$           11   Maiz          50       1.5$  75$       
   5    Bity          400      4$    1600$          12   Rice          50       1$    50$      
   6    JJ            12       1$    12$            13   Bity          40       4$    160$
   8    Put           33       1$    33$            14   JJ            12       1$    12$                   
                                                    16   Put           33       1$    33$
..........
 

This means two Rows and Three Columns starting from Jan to June
as follows

Month Jan          Month Feb        Month March
........           ........         ...........
........           ........         ...........
........           ........         ...........
........           ........         ...........
........           ........         ...........
........           ........         ...........
........           ........         ........... 
 
Month Apr          Month May        Month June
........           ........         ...........
........           ........         ...........
........           ........         ...........
........           ........         ...........
........           ........         ...........
........           ........         ...........
........           ........         ...........
 

This summary will help to make the report presentable.
I have tried to use columns in Access PrintPriview windows but it couldnt do the way I want!
Please help!!!

[TheSmileyCoder]

Assuming you are able to create the individual month reports yourself, one approach could be to add a table with 1 column, tx_Month, with 6 records "jan","feb"....
Then base a report on this table, and insert your monthly based report as a subreport, linked through the monthname.