Compare a Field to a Field in a Prior Record with Large Datasets

[aaron_a]

Referencing this example from Microsoft Support:

ACC2000: How to Compare a Field to a Field in a Prior Record

This example works with the limited dataset provided but if a new dataset is created which is much larger it randomly deletes, or doesn't delete, a record(s).



Does anyone have any experience using this type of querying within a query using large datasets and/or why it is causing this problem.

Attached is the example from Microsoft support with the added table and query that simulates a "large" dataset.

Thanks,
Aaron

[aaron_a]

I copied this topic to another Access forum to get more exposure to the problem and some discussion (and clarification of the problem) has started there:

http://www.access-programmers.co.uk/...d.php?t=166729