displaying fields based on last record shown in form

[capdownlondon]

I've designed the following report but cannot get it to do what i want.
The source of the report is all from the same query.
What i want is for the targets(1-5) to be displayed based on the record from the last set of fields displayed on the bottom section of the form.

here are the print screen to show what i mean:

Report:

Report Design View:

Thanks

 

[rainman89]

you want it based on the last week entered? how is the information being entered so that u can get it to the report?

 

[capdownlondon]

the form get the other records straight from the fields on a query.

 

[capdownlondon]

Sorry to be clearer. I want the targets to be from the same rocrd of obviously that child, and from the same week as the last record(date wise) for that child.

At the moment it displays the average points score for all weeks on record, in order, but each week may have different targets related to it, so i just want the targets from the most recent record.