You're right, SQL was getting confused.  The column I named "Team" was giving me the strange result because I the column name in the refund_form table was also name "Team". ...

Thank you so much for all your help. Never really used case statements in SQL before. This definitely gave me some valuable experience.

OK, I made the dupe thing moot by you helping me put it at the end of the recordset where it won't bother anyone. I truly appreciate your help. Now...

I'd just as soon not even show that line cause I still have the format trouble

oops, spoke too soon. The rollup isn't working now. I get no errors though, it just acts like I didn't say 'with rollup', no totals

you da bomb. can you come live at my desk? I'll get you one of those nice air matresses...

Thanks! That worked perfect!

But I'm having trouble formatting that 1st line. when I try and format the cell/line it gives me that cell twice.

if instr(thisfield,"All") then

...