AnsweredAssumed Answered

Unique Counts with Execute SQL

Question asked by kdunn@mywestamerica.com on May 26, 2015
Latest reply on Jun 1, 2015 by philmodjunk

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?

 

Outcomes