Cannot figure query

Pvarga

Registered User.
Local time
Today, 00:53
Joined
Apr 6, 2002
Messages
50
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.
 

Users who are viewing this thread

Back
Top Bottom