Search results

  1. S

    Report on Customers who've not ordered in the last 3 months

    Thanks RichO placed this string: Select CustID From Cust Where Not In (SELECT CustID FROM CustOrder WHERE OrderDate > DateAdd("m", -3, Date())) but get missing operator error. If I replace In with Exists, it goes through but returns no rows Siggy
  2. S

    Report on Customers who've not ordered in the last 3 months

    Hi, I'm new here, so go gentle with me! here's my issue (and I'm sure the answer is simple): Say I have a DB with Customers and Orders. I want to produce a report of all customers who have not ordered in the last 3 months. I know how to filter out the last 3 months, but I obviously need to...
Back
Top Bottom