AnsweredAssumed Answered

Where do I put my ExecuteSQL calculation?

Question asked by JillianDunic on Oct 15, 2012
Latest reply on Oct 16, 2012 by philmodjunk


Where do I put my ExecuteSQL calculation?


     Do I create a new field the table that I want to query in and use an autocalculation where I use ExecuteSQL? Or do I create a new layout where I can put my query fields as I continue to select various pieces of data? I find it confusing to wrap my head around where I put my ExecuteSQL statement because it will only produce a single result of text. For a simple example I want to find the distinct values in a field called 'Tray Name'. How and where do I do this?