Thanks for the help! :-)

I used the union statement last night and was close but went home. I copied your stuff over and tried it and it worked except for one small thing. ONe of the banks had an " * " in the found column. I noticed that the code put two occurrences of the bank in and some with only one occurrence. This " * " of course caused a problem with the rest of the record.

I changed the " 0" you had in there to 0.0000. i.e.
COUNT(isnull(newmid)) AS nofound , 0.0000 as found ;

This seem to solve the porblem. I remember seeing code a long time ago with some kind of formatting in it for the fields.
Do you know how to do this or know what it is called?