I can not group the report as previously posted since the field I want to group on to do a count contains the "Next" and "Previous" functions.

If I do a formula to return a different record based on those fields it won't let me count or group it.

For example I used the following on the above formula posted earlier with an InStr formula:

if instr({@description repeats},"NO - OK")>0 then 1 else
if instr({@description repeats},"YES - REPEAT!!")>0 then -1 else 0

This returned exactly what I wanted on the report. Problem again is when I go to insert a sum(count) or try to group on this formula I can't since it references the original Next and Previous functions in the original formula.

Assume a workaround but at this point I am lost.

Thanks in advance for any postings.

Issue "Resolved" - As frustation built I should have done this in the first place. I just exported the resulting printout to an Excel file and sorted it that way.

Thanks keviray for your input. Would still like to know if possible since I sure as you know what figure it out.

Thanks again kevlray. I appreciate your input. Unfortunately no on the MS-SQL but make note of your functions anyway.

Thanks for your input.

Still searching for an answer.