Assistance with Query - Show with count > 1 between 2 dates

[torz]

Hey guys,

attached the db again - if you look at the so called "Finally working" query (think I went off a little 1/2 cocked when I named it haha )

It still seems to be ignoring the date criteria for some but not all of the rows...

There is 4 rows of data for 2000000000 & only 3 show in the query which is PERFECT! but the other custid should not be shown at all because they are not within the last 7 days

 

[torz]

does anyone have any idea why this is still showing a record for CustID that does not have a count of >1 within the last 7 days??