Thanks for the replies. It is a bit disappointing to hear what Mr
Starkey had to say. Just have to roll with it, then. Sorry I do not
have any experience with rivers, streams and tributraries (other than
sinking in them), but I'll gladly volunteer as a beta tester for
Firebird development.

Sorry for the typo in the second query. It was meant to read:

SELECT b.desc1, SUM(b.qty) FROM summary1 a
INNER JOIN cti_ b ON a.trxmdate = b.trxmdate
GROUP BY b.desc1
ORDER BY 2

Regards
Ray Mond