Nope. The opposite. I think the NOT in the select statment is messing you up...
You are gouping on Acct#.
then you are flaging any row in the group where the date is > 9-5-05 with a 1.
Then you sum that "flag" at the group level. Any group > 0 means it should be exluded so that becoems your select criteria (but it is at the group level not the row level). Slect criteria have to return TRue (include) or FALSE (exclude).
To make it easier you can just use:
summary=0
instead of the NOT i gave you earlier. I did that because in some cases summaries are not done at all (NULL) and the NOT accounted for that but I don't think you need to worry about that here.
Edited by DBlank - 03 Sep 2009 at 10:01am