Hi Peter,

The SQL that I gave you does this. It's giving a count of "R" and "I" from IRA per GROUP_NO. Have I misunderstood what you're trying to do?

Gavin...

>i NEED TO CHECK TO SEE IF THE GROUP NO IS EQAUL TO EACH OTHER. ONLY WHEN THEY ARE EQUAL TO COUNT FOR IRA = "R" OR "I" AND WHEN THEY ARE NOT EQUAL REST THE COUNTERS THEY WAY THE PROGRAM IS WRITTEN IS WHAT i WANT IT IS JUST NOT COUNTING RIGHT, BECAUSE THE COUNTER IS NOT RESTING...