How to create this report

[Dou]

My table structure:

OrderNo Text 20
Color Text 20
Size Text 20
OrderQty Integer
ShipVia Text 10
DelDate Date 'Delivery date


Table Content:

OrderNo Color Size OrderQty ShipBy DelDate

----------------------------------------------------------------------------
----

L60092 04Marine 4A 46 Sea 30-Jun-05
L60092 04Marine 5A 32 Sea 30-Jun-05
L60092 04Marine 6A 69 Sea 30-Jun-05
L60092 04Marine 8A 106 Sea 30-Jun-05
L60092 04Marine 10A 133 Sea 30-Jun-05
L60092 04Marine 12A 134 Sea 30-Jun-05
L60092 04Marine 14A 115 Sea 30-Jun-05
L60092 04Marine 16A 65 Sea 30-Jun-05

L60230 17Beige Clair 4A 8 Air 30-Jun-05
L60230 17Beige Clair 5A 6 Air 30-Jun-05
L60230 17Beige Clair 6A 11 Air 30-Jun-05
L60230 17Beige Clair 8A 17 Air 30-Jun-05
L60230 17Beige Clair 10A 24 Air 30-Jun-05
L60230 17Beige Clair 12A 17 Air 30-Jun-05
L60230 17Beige Clair 14A 22 Air 30-Jun-05
L60230 17Beige Clair 16A 4 Air 30-Jun-05


This size quantity is not fix, when the size quantity is eight,I want to
create the foolwing report format:


OrderNo Color\Size 4A 5A 6A 8A 10A 12A 14A 16A Total
ShipBy DelDate

----------------------------------------------------------------------------
----

L60092 04Marine 46 32 69 106 133 134 115 65 700 Sea
30-Jun-05
L60230 17Beige Clair 8 6 11 17 24 17 22 4 109 Air
30-Jun-05

----------------------------------------------------------------------------
----

Total 54 38 80 123 157 151 137 69 809

when the size quantity is five,I want to create the foolwing report format:

OrderNo Color\Size 4A 5A 6A 8A 10A Total ShipBy DelDate

----------------------------------------------------------------------------
----

L60092 04Marine 46 32 69 106 133 386 Sea 30-Jun-05
L60230 17Beige Clair 8 6 11 17 24 66 Air 30-Jun-05

----------------------------------------------------------------------------
----

Total 54 38 80 123 157 452


This size quantity is not fix. How to create this report? thanks

 

[Duane Hookom]

At least one reply to a similar question in another news group. There are
examples of various crosstab reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4