Get the last date entry

[zab]

Hello

I need to bring the percentage of achievement of a task in a related table and I just can't find the way.

I have a table in which I store the % of achievement of a particular task. The % is updated every week until is reach 100%. So I'm looking for a way to bring the last entry (closer from today's date) % in a related table. So far I only managed to get the first entry whatever the date is.

Any idea?

Thank you

[Raybaudi]

So far I only managed to get the first entry whatever the date is...

... but if you order the relationship by descending date...

[comment]

... or use the Last() function...

[zab]

... but if you order the relationship by descending date...

YESSSSSS it's working.

Thank you

About the Last() function. I didn't find the way to do it that way because I have to show the percentage field... anyway the other option is working.

Thank you all