The result you show is what I get when there is a bank in the right file and not in the left. I had all that other stuff in there just trying anything to see if something would work. I don't ordinarily put the WHERE and GROUP in there if not needed.


I found out that this was an error in VFP 3 or 5 in the knowledge base. It is suppsed to not exist in VFP 6 but I say it does. Iwent out and did some experimenting and found it to be true.