>Once more, let it be said far and wide - Sergey is the SQL Man!
>
>Thanks Sergey it works wonderfully! This will be a keeper snippet.

You're welcome and here's another way to get the same result.

SELECT name, amount, official, date FROM cmoney cm1 ;
	WHERE (official = ?Official1 AND EXISTS( SELECT * FROM cmoney ;
			              WHERE name = cm1.name AND official = ?Official2)) ;
		OR (official = ?Official2 AND EXISTS( SELECT * FROM cmoney ;
			              WHERE name = cm1.name AND official = ?Official1)) ;