Hi everybody.

It would be great if someone of you could help me resolving the following
problem.
Please have a look at Excel table.
(Please reply to my email adress so I can send you a zipfile (14Kb) with
the Excel table who explains the problem to resolve)

tbl1

IdNr (Prim Key)
Level INT
NameOfGroup VARCHAR (30)
Account VARCHAR (16)
GroupType VARCHAR (1)
Class VARCHAR (1)

tbl2

EntryId (Prim Key)
Date DATETIME
Account VARCHAR (16)
CAccount VARCHAR (16)
Amount MONEY

sp1 (needed)

IdNr
NameOfGroup
Account
Amount (for accounts and sum of accounts, for groups)

Please send any solution to my email address.

Many thanks for any suggestions.

Edi