Calculating Previous lines

[jmagness]

Can somone give me advice on calculating from a previous
line. An example would be I am rendering a report of
times, and lets say there are 10 times, and I want to
calculate the difference from the previous time at each
line.

 

[Larry Linson]

Save the value, using the unique ID of the record, to ensure that you only
do it once for each detail, in a variable, then use that variable in a user
defined function. Problem is that the Format and Print events may be
executed more than once for the same record, so you have to be careful that
you are using the correct value.

If you need to follow up or clarify, please do so here in the newsgroup, not
by email.

Larry Linson
Microsoft Access MVP

 

[Xcelsoft]

I got this to work by storing the value during the On
Format event of the detail section.

Thanks,

Xcelsoft