Open report - getting value from table ?

[ooops]

In the expression builder for my text box (on my report) I have:

="I hereby acknowledge receipt of the " & [tblJCode]![Correction_Year] & " correction..."

How do I query it to the record I want ? In this case it should go to the last record.

Thanks.

 

[SiJP]

Hi ooops.

Try this:

="I hereby acknowledge receipt of the " & DMax([Correction_Year],"tblJCode&quot


In this example I have values 2001 - 2004 in the field.

Any good?