In your report field, make your field be conditional statement. So assuming you had a field called txtType2, the formula would be "=iif([type2]=Null,"X",[type2]) petersdaniel@hotmail.com
"If A equals success, then the formula is: A=X+Y+Z. X is work. Y is play. Z is keep your mouth shut." --Albert Einstein