How to retrieve the last updated record froma table and displayit in textobject

[#1]

Hi all,

AS per  the below attached excel file.. i am having a table with field names

[database name],

     [Last successfull reload date time],

     ErrorDate,

     ErrorTime,

     QVWname,

     ScriptError,

     ScriptErrorCount,

     ScriptErrorDetails,

     ScriptErrorNo

...So what i wanted is that.. i want to get the QVWName and the database name as per the last updated  error time...in this case the errortime is 14-4-2014 12:15:43..............and this is what i need to display on a text object.

So what i need in the output in the text object  is that:   ERROR OCCURRED IN DATABASE NAME:stflush AND QVWNAME:TitanExtract-InvJrnl.qvw... It will be very helpful if sumbody can help in solving this problem.

Thank You

[Gysbert_Wassenaar · Accepted solution]

='ERROR OCCURRED IN DATABASE NAME: ' & FirstSortedValue([database name], -ErrorTime) & ' AND QVWNAME ' & FirstSortedValue(QVWname, -ErrorTime)

[#3]

Hi,

  thanks a lot ...your expression really helped....