Query emergency
I have a query that I need to complete in the next hour or so. I am trying to find if any 1 customer number has had over 4 billings in over a rolling 6 month period (any order - 6 months later).
I can not figure out how to do this.
In my query I have 1) Customer Number, 2) Invoice Number 3) Date.
How do I make it only show customers that have over 4 separate invoices in any 6 month time period.
Thanks in advance.
I have a query that I need to complete in the next hour or so. I am trying to find if any 1 customer number has had over 4 billings in over a rolling 6 month period (any order - 6 months later).
I can not figure out how to do this.
In my query I have 1) Customer Number, 2) Invoice Number 3) Date.
How do I make it only show customers that have over 4 separate invoices in any 6 month time period.
Thanks in advance.
