Like a charm
pbaldy,
That worked like a charm!! Thank you for replying to my post. I didn't really understand the IIF expression and know seeing how it works I get it. It also helped me to realize a few other things that I could do, ie, IIF([MFG]="abc",IIF([R/T/W/S/E]="R",[ROYALITY],45))...