Assistance with Query - Show with count > 1 between 2 dates (1 Viewer)

torz

Registered User.
Local time
Today, 13:48
Joined
Jun 21, 2014
Messages
73
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 :p)

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
 

Attachments

  • Sample DB (1) (1).accdb
    864 KB · Views: 68

torz

Registered User.
Local time
Today, 13:48
Joined
Jun 21, 2014
Messages
73
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??
 

Users who are viewing this thread

Top Bottom