Genrate Dynamic Labels in Header part of Access Reports....???

Hi all,


i have genrated one report in Access, source of this reports is access Query

this reports show me, Records for Order and OrderItems for each customer
suppose customer ID 1 place order 2 and order2 have 3 OrderItems then the Data is display as follows

VB Code:

CustomerID = 1
 
  OrderNumber = 2 
 
  OrderItemNumber    OrderItemName                  OrderQty        Size
 
            1               COMPV Fieldberry Drink            2              2.86ML
            2               COMPV Fieldberry Drink            1              2 ML
            3               COMPV Fieldberry Drink            3              2.68ML   OrderNumber = 3 
 
  OrderItemNumber    OrderItemName                 OrderQty       Size
 
            1               COMPV Fieldberry Drink            2             2.86ML

up to this my Report is ok

now i want to modify my Reports as

VB Code:

CustomerID = 2
 
OrderNumber = 1 
                                                                      2.86ML   2ML   3.78 L
                                                                       ====    ====  ==== 
                                                                         2          1        3 
 
 
OrderItemNumber        OrderItemName                OrderQty       Size
 
            1               COMPV Fieldberry Drink            2             2.86ML
            2               COMPV Fieldberry Drink            1             2 ML
            3               COMPV Fieldberry Drink            3             3.78 L

pls help me regarding this
thanx and regards,

Are you doing this all in Access? Can you post your query?

yes i am doing all this in Access

problem is not in Query i want to show the value in header i am attachin the images first image show my current Report and i want to do modification as in second images

thanx and regards,