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

    Help with ExecuteSQL Query

    BrianBrouillette

      Title

      Help with ExecuteSQL Query

      Post

            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" ; "" ; "")

           Notes:

                  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