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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Determining the Sequence Number of random lottery values 2
How do I? (Access Tabe Sequencing/VBA/Array question) 2
How to get a sequence number in a query 5
How to get sequence number in the next column? 2
Sequence number 1
Replacing string with number sequence 0
Finding numbers not in sequence 3
How do I sum a column based on 2 different column headers/criteria? 0

Back
Top