R
Richard
Can't replicate what was simple 7 or 8 yrs ago. Each new
record in this database is the day after the previous
record - 7 days a week. I want the new record to do a
DLast Lookup of the previous record's date from the
[DATE] control(field) and enter it in the new record's
{DATE] control. Same thing with the [DEPOSIT(Prior)]
control. This involves two fields: [DEPOSIT] and [DEPOSIT
(Prior)]. I want the currency information from the
previous day's record in the [DEPOSIT] field entered into
the new (next day) record's [DEPOSIT(Prior)] field. Note:
when I say control I am referring to my form. The
[DEPOSIT] field is actually a calculated expression in
the query that the form is based on. The idea is to add
and/or subtract values from other fields including the
[DEPOSIT(Prior)] field which I currently enter the value
manually by looking up the info in the previous record. I
did this 7 or 8 yrs ago by using specific examples that I
found in some manual. Can't find an example in the
NorthWind database either.
record in this database is the day after the previous
record - 7 days a week. I want the new record to do a
DLast Lookup of the previous record's date from the
[DATE] control(field) and enter it in the new record's
{DATE] control. Same thing with the [DEPOSIT(Prior)]
control. This involves two fields: [DEPOSIT] and [DEPOSIT
(Prior)]. I want the currency information from the
previous day's record in the [DEPOSIT] field entered into
the new (next day) record's [DEPOSIT(Prior)] field. Note:
when I say control I am referring to my form. The
[DEPOSIT] field is actually a calculated expression in
the query that the form is based on. The idea is to add
and/or subtract values from other fields including the
[DEPOSIT(Prior)] field which I currently enter the value
manually by looking up the info in the previous record. I
did this 7 or 8 yrs ago by using specific examples that I
found in some manual. Can't find an example in the
NorthWind database either.