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?
Thanks in advance for your help! :-)
Randall L. Johnson