Make this work?

  • Thread starter Thread starter HelpMe!
  • Start date Start date
H

HelpMe!

SELECT AllInfo.ID, AllInfo.Period1Start, AllInfo.Period1End,
AllInfo.[1CompletionDate], AllInfo.Period2Start, AllInfo.Period2End,
AllInfo.[2CompletionDate], AllInfo.Period3Start, AllInfo.Period3End,
AllInfo.[3CompletionDate]
FROM AllInfo
WHERE (((AllInfo.Period1Start) Is Not Null) AND ((AllInfo.[1CompletionDate])
Is Null) OR (((AllInfo.Period2Start) Is Not Null) AND
((AllInfo.[2CompletionDate]) Is Null) OR ((AllInfo.Period3Start) Is Not Null)
AND ((AllInfo.[3CompletionDate]) Is Null));

I am trying to return blank completions dates for 1, 2, or 3 fields
 
Try this --
WHERE (((AllInfo.Period1Start) Is Not Null) AND (AllInfo.[1CompletionDate])
Is Null) OR (((AllInfo.Period2Start) Is Not Null) AND
(AllInfo.[2CompletionDate]) Is Null) OR (((AllInfo.Period3Start) Is Not Null)
AND (AllInfo.[3CompletionDate]) Is Null);

You really should normalize your table this way --
AllInfo.[ID]
AllInfo.[PeriodStart]
AllInfo.[PeriodEnd]
AllInfo.[CompletionDate]
AllInfo.[Period]
 
Back
Top