Method Community

Hey Mortaza, Thanks for the quick response.  Maybe there is another way we could approach this request.  I think it is a pretty good idea and that other users may find it useful as well.  Here is the objective:  To categorize our customers into groups based on their order history.  Example: Category 1 Customers order ...

Hi Mortaza, Thank you again.  It worked wonderfully.  However, I am unable to use the 'greater than' or 'less than' filters on the customer list for the custom columns.  Any idea what I could do to get them working? Thanks,  Ben

Hey Mortaza, Thank you!!!  What a wonderful welcome to the Forums.  Your code worked like a charm. A quick follow-up question:   How would you use SQL to retrieve "Number of days since most recent invoice"," if that is even possible? Thanks a again! Ben

Hi Mortaza, I have a request that is very close to this solution.  Could you help me create a field for my contacts grid that will show me the total number of invoices.  I intend to use this to be an easy way to see customers that have re-ordered. Thank you in advance, Ben