1 Reply Latest reply on Feb 12, 2014 8:58 PM by davidanders

    Help with ExecuteSQL Query



      Help with ExecuteSQL Query


            Hi -- I am trying to find unique members on a list and come up with a count.  In this case -- the field is "Customer" and I want to get the name of unique customers on list (one customer may be on the list many times)

           The Query I am trying:

           ExecuteSQL ("SELECT COUNT ( DISTINCT Customers)FROM RE Plan 2.0 Converted" ; "" ; "")


                  The field name is Customers

                   The file is RE Plan 2.0

                 The results of query are "?"  and it should be 15

           Thanks in advance for your help