I have a table 'TASKS' and 'TASKS_AUD' (Audit table that contains all the updates, Deletes done to table TASKS)

I have to compare the ISRESOURCEREQUESTED column of 'TASKS' with the LAST record of ISRESOURCEREQUESTED column of 'TASKS_AUD'

How do I do it?

I have now implemented it as :

REPORTMODIFIED/A3 = IF TASKS.TASKS.ISRESOURCEREQUESTED NE LAST TASKS_AUD.TASKS_AUD.ISRESOURCEREQUESTED THEN 'YES' ELSE 'NO';

But this pulls out multiple records for every task. I just want one distinct record....

please could anybody help me on this..

This message has been edited. Last edited by: Kerry,

SUM instead of PRINT?

And the input file must be in the correct order for the LAST function to work.

Thanks Francis. Doing 'SUM' worked