Getting data from a stored field.

[LearningAccess]

Hi all,


I've tried searching for this but always come up with a slightly different answer.

Here's my question, how do I recall data from a field belonging to a record.

My database tracks project of a task. So, each week ending has shows a list of the tasks gathered from another table.

Week Ending----------Task----------%Complete
1/01/16 Task1 10%
Task2 20%


08/01/16 Task1 15%
Task2 30%

When i start a new record "week ending" i'm shown the tasks available and i'm able to inset a %complete into that field. At that stage i would also like to compare the previous weeks percentage from that task?

I have drawn a text box in my sub form but i have no way of recalling the previous weeks record but not sure if this is right?

I'd be very great full if you could help me.

Thanks in advance.

[June7]

This is something best done in a report.

Pulling a value from another record requires subquery http://allenbrowne.com/subquery-01.html#AnotherRecord

or domain aggregate function such as DLookup().

[vicsaccess]

without knowing your structure its hard to tell. is each week and their percentage stored in a table or just equated? if stored then use a query behind it.

[NTC]

well - "previous week" must be identified specifically based upon your current week. there is more than 1 way to skin this cat and it somewhat depends on how much code and the structure of your data....

but to call another record's data (in this case previous week) into the current record in order to do a calculation requires a query that will result in just the previous week's record - save that with a name PreWeek

then you could use a DLookUp method to get the data (you'll want to look that up online)...or possible you could do a join to the current record....or again rely on a sub form.... it all depends on the interface you are developing.