Unique Counts with Execute SQL
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?