Referencing this example from Microsoft Support:
ACC2000: How to Compare a Field to a Field in a Prior Record
(If the link does not work because I am a new member it is from support.microsoft.com/?id=208953)
This example works with the limited dataset provided but if a new dataset is...