How can I check sequencing in a number column in Access?

T

TRIGEO

If the normal sequence in the column is 1, 2, 3, 4, 5, ...., how can I
identify situations where the sequence has been distorted, e.g., 1, 2, 4, 3,
5, ... when there are thousands of such groupings within the column.? I do
not want to know how to correct the mis-sequence(s); I just need to know how
to find them.
 
J

John Spencer

Unless the sequence is dependent on some other field (column) there is no
way to determine that the sequence is out of order. Records are like a bag
of marbles and have no innate (built-in) order. You set the order by using
a query and specifying the order in the query. For a report, you specify
the order in the Report's sorting and grouping dialog.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Top