G
Guest
I'm trying to use Access to generate investment performance statistics for
our investments. I have the following table structure:
Table Name: Performance
Fields: ID, Date, Return
ID Date Return
1 01/01/2004 1.5%
1 02/01/2004 0.85%
1 03/01/2004 -2.75%
1 04/01/2004 5.50%
Question: I need to retreive the previous record for each ID in order to
compute an annulized yield on my investment. Should I use DLookUP or is
there a better way to do this? What is the correct way to use DLookUp with
my example?
our investments. I have the following table structure:
Table Name: Performance
Fields: ID, Date, Return
ID Date Return
1 01/01/2004 1.5%
1 02/01/2004 0.85%
1 03/01/2004 -2.75%
1 04/01/2004 5.50%
Question: I need to retreive the previous record for each ID in order to
compute an annulized yield on my investment. Should I use DLookUP or is
there a better way to do this? What is the correct way to use DLookUp with
my example?