Data Formating in Access Report

[nileshhthakur2004]

hi all

i have one report in which i am displaying Customer's Order and OrderItems
in this reports i populate the query as CrossTab Query which display me size as column heading as follows

CustomerID = 3

OrderNbr OrderItemNbr Product Name Size RequestedQty ShipeedQty
--------------------------------------------------------------------------
7 1 EQ Bottled 300 ML 2 2
7 2 EQ Fruitland 2 L 3 2
7 3 EQ Apple 2 L 4 2

Custromer = 4

OrderNbr OrderItemNbr Product Name Size RequestedQty ShippedQty
--------------------------------------------------------------------------
8 1 Cranberry 3.78 L 2 2
8 2 Mango Drink 375 ML 3 2

and currently my report is look's like as follows


Company Name : A & P

OrderNbr 7

OrderItemNbr ProductCode ProductName 2L 3.78L 300L 375ML
--------------------------------------------------------------------------
1 EQ Bottled 2
2 EQ Fruitland 3
3 EQ Apple 4



OrderNbr 8

OrderItemNbr ProductCode ProductName 2L 3.78L 300L 375ML
--------------------------------------------------------------------------
8 1 Cranberry 2
8 2 Mango Drink 3

i want it to show reports as follows how can i do this ??


Company Name : A & P

OrderNbr 7

OrderItemNbr ProductCode ProductName 2L 300L
--------------------------------------------------------------------------
1 EQ Bottled 2
2 EQ Fruitland 3
3 EQ Apple 4



OrderNbr 8

OrderItemNbr ProductCode ProductName 3.78L 375ML
--------------------------------------------------------------------------
8 1 Cranberry 2
8 2 Mango Drink 3


pls help me regarding this ....

thanx and regards