I am not asking you to do it for me, I only need an idea to get me out of
this mess, please...

I am trying to create a report based on three tables with the following
(identical) structure: Type/Year/Month/Category/Dimension/Qty/Amount. Based
on them, I need to produce a report which would look like this: for each
Year/Month, I should have the following columns:

Dimension,
Category,

RET.Qty, - from table RET
Ret.Amount, - from table RET

NORET.Qty, - from table NORET
NORet.Amount, - from table NORET

OUT.Qty, - from table OUT
OUT.Amount. - from table OUT

The records should be grouped by Year/Month, of course, but also by
- each Category (I have three, A, B, and C)
- each Dimension (I have two, 48 and 60)

That means that for each Year/Month combination I should have 6 rows:
48 A
60 A
48 B
60 B
48 C
60 V
and for each row I should have totals of Qty and Amounts.

So for Year X/Month Y the report should look like this (where Qty is the sum
of Qty and $ is the sum of Amount):

Dimension    Category    RetQty    Ret$        NoretQty    Noret$    OutQty
Out$
_____________________________________________________________
48                A                19            20        22
38            48            93
48                B                73            93        32
19            84            92
48                C                23            19        29
20            49            16

60                A                61            91        73
35            38            81
60                B                51            15        72
83            63            66
60                C                14            32        63
77            83            61

I have tried with subreports, but I can't find the way to group & link them
properly. Can you please, please, please give me some ideas on how to do
this ?

Thank you very much.
Alex.