Recent content by mike4100

I've tried a number of things and nothing is working. I guess I need to try this a different way maybe a function. Thanks for helping.

I would do that but I really can't using the logic I have been given. How would you rewrite it?

I have the following statements and keep getting "YES" where I should be getting "WAIVED" or "NO". Does anyone know why, everything else evaluates correctly. IIf([admit_dec_code] Is Null Or [admit_dec_code]="R","",IIf([admit_dec_code] Is Not Null Or [admit_dec_code]<>"R" And...