Have a table with customer ID, transaction date, transaction $amt. Multiple transactions for multiple customers over multiple dates. How can I determine if any customer has transactions totalling $1,000 over any 30-day period?
Thanks for any help.
Thanks for any help.