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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
..
 
Back
Top