Please help: Unique problem

I have a Crystal 8 report to print a packing slip with following Access Database fields:
Currently print on report and is OK for domestic use

items.Qty items.description items.CtnNo

items.Qty items.description items.CtnNo

5 Motherboards #1
3 VGA Cards #1
2 Keyboards #2
3 Modems #2
1 Case (loose item)
1 Screen (loose item)

Packing note should be (required by customs at Botswane border post)

5 Motherboards
3 VGA Cards
All above packed into Carton #1
2 Keyboards
3 Modems
All Above packed into Carton #2
1 Case
1 Screen

In other words no case number next to each item but under neath the items that is packed packed in Carton # 1 the wording as above

Sequence must be all in cartons first sorted by carton number then followed by the loose items

Suppose I should create a formula or formulas of some sort but are at a loss. Tried different ways but no luck


In other words no case number next to each item but under neath the items that is packed packed in Carton # 1 the wording as above

Sequence must be all in cartons first sorted by carton number then followed by the loose items

Suppose I should create a formula or formulas of some sort but are at a loss. Tried different ways but no luck