>Hi Bret,
>
>My example was simplified, sorry if it doesn't make sense. (The example seemed good at the time <g>) The report needs to sum the dollar amounts and give a "Cross-Reference" to current eligibility. Not to show which Plan will be charged.

Since John K. has described considerable familiarity with these insurance problems, he's probably way ahead with a solution whenever he's available. The rest of us will need a much more complete description of the rules to be implemented. Some of us prefer a SQL solution. I find that SQL either works perfectly or not at all, and I rarely find hidden problems. xBase can sometimes be faster, and some people find it easier or better for them.

>I always forget about non-equal joins. I'll have to give these a try. I won't be able until next week, however as I'm getting ready to go to DevConnections. Are you going to be there?

No.