compare current and previous records using recordset

[qwkslvr1999]

How will I be able to compare a current record with the previous record using rst?

 

[Rich]

Use the PrevRecVal function

 

[David R]

Rich, you keep mentioning this function and I cannot find it in the Acc2k help files, either regular or VBA. What are you using to get to the help file, please?

 

[Rich]

Article ID: Q101081

From the downloaded MS knowledge base