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 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