4 Replies Latest reply: Aug 15, 2014 5:36 AM by Jonathan Ditchfield RSS

    Finding the Max Value in Text Object



      I have a specific query where I need to find the information from my field updatetxt depending on the value of another field udindex.  I created a text object and on my expression wrote the following:




      However the text field is blank.  I suspect this is because my udindex can be anywhere from 1 to 113 and therefore when I click on the specific record that has a primary key of callref, it cannot see which text field I need.


      Is there a way that I can add in my expression to get the data from updatetxt depending on the MAX value?




      Jon Ditchfield