I thank you for the reply to my previous post.

I have one more. I will put up what I did:

NumCompLevColD: IIf([Posttest Score]>=[Pre-Level] And [Withdrawal Date] Is Null Or [Exit Date] Is Not Null And [Posttest Score]>=[Pre-Level],"Completed Level")

Okay I want this col to put the word Completed Level if the posttest score is >= the pre and they have no withdrawal date. An exit date is okay. If there is no exit or WD and the post score is => than pre I do not want completed to be put in the col. But as it stands now if the post score is = and both date are blank it is going into this and that creates a dup since I have them in another col too. I hope I have not been too confusing. This is part of a six col. report and my head is spinning. I am teaching myself Access.

I appreciate any help.

Tricia

I will suggest an old tried-and-true issue for you - grouping.

Add parentheses around the times you want handled together. I almost NEVER trust expressions that don't have explicit grouping but DO have more than one operation in the line.

IIF( (A and B) or (C and D), etc. etc. etc.