9 Replies Latest reply on Jun 1, 2015 9:44 PM by philmodjunk

    Unique Counts with Execute SQL

    kdunn@mywestamerica.com

      Title

      Unique Counts with Execute SQL

      Post

      I have a table that data is being imported into. One of the fields is "Tracking Number" when I do a find for a date range I would like to display the number of unique shipments. I have a single table "Orders". My field is a calculation number called "Total Shipments" - ExecuteSQL ( " SELECT COUNT ( DISTINCT Tracking Number) FROM Orders" ; "" ; "" ) . My field is always blank and it is not calculating. Any ideas?