> Can anyone see what I'm doing wrong here? hi jay i'm guessing you're using microsoft access try the IIF function -- you have IF rudy