You were seeing no results or getting the error for groups with less than 3 detial rows.

yeah that is a good point. i have it set up and fine tuning it to show correctly but so far this is what i'm getting.

every employee has 7 tax codes for various taxes according to payroll. so on the footer where all the records are shown in 1 line for this it will show like

NNNYNYN

becuase it's evaluating every tcode and answering accordingly but i only need a single Y if the employee as SS or MED tax code or a single N if they do not.

If i do something like this Shared StringVar Fica := Left(Fica,len(Fica)-6); in the footer then it will only show the last evaluated tcode instead of a correct Y or N.

Thanks for your help thus far. I'm just missing something.

sorry if i confused you there. what i am looking for a Y if any row has SS or MED

OR

an N if NO row has SS or MED.

for testing i tried this in my detail

Fica := Fica + (If instr(Fica,{@Fica})>0 Then "" Else {@Fica});

and that returns 1Y and 1N so then i tried what you suggested with the len-1 in my footer but that only shows N even though it should have been a Y

you could also change your other formulas if you want...