I'm investigating the use of the ExecuteSQL Fetch command and as far as I can tell it will only return whole rows of data, not specific fields.
What I need is the top 25% of results from the overall table for a given criteria. The reason I'm using ExecuteSQL is because at the stage I need to bring this particular calculation to my report, I have the need to be working in a certain found set. AFAIK native FM commands won't access records outside of the found set.
Thanks in advance