Displaying records

[Paradigm]

I have 2 tables one with tasks and a taskID and one with
PercentageCompletions, WeekNumber and a taskID to link it to the tasks
table. The percentage completions are entered weekly.
I want to display, on a single form, a list of tasks, the percentage
completion last week and the percentage completion this week where this
weeks figures can be entered.
I think I need to set the control source of the percentage completion fields
to display the correct data (i.e. one for last week and one for this week)
but I am not sure how to do this.
Alec

 

[Allen Browne]

Use a subquery to read the most recent value for the same TaskID from the
same table.

Details in:
http://allenbrowne.com/subquery-01.html#AnotherRecord

Alternatively, if you need this in a form where you can still edit your
data, use DLookup().
http://allenbrowne.com/casu-07.html
It will be slower, but updatable.