How do I move row information down several spaces ?

  • Thread starter Thread starter Vanessa
  • Start date Start date
V

Vanessa

In 2003 Access how do I move row information down several spaces in the same
column? I want to add new information in between.
 
In a table you can not. Records in a table are like a barrel of bricks, in
no exact order. You order them in a query by sorting or report by using the
Grouping and Sorting.
So to make sure the records are displayed in an order you desire there needs
to be a field that you sort on. You can add such a field and not display it.
A suggestion would be a number field set to double and number each
incrementing by 10 so as to add the in-betweens.
 
Back
Top