HELP ADDING RECORDS

  • Thread starter Thread starter Katrina Kleinhans
  • Start date Start date
K

Katrina Kleinhans

I need to know how to add a record inbetween two records
that I already have. I have been looking in the help, in
books, and on the internet and can't find anything about
that. If anyone knows how to do this please let me know
or if you know of a different way to do this.

THank you
Katrina Kleinhans
 
There is no "between" in Access records. Records in a table have no order
until you apply an order. You must store a value or values in the table that
describe or desired sort order. Changing the value of a "sort field" will
allow you to display your records in different order.
 
Katrina

Duane's already pointed out that an Access table is a "bucket-o-data", with
no order unless you provide a way to tell Access how you wish to see the
rows ordered.

I'm curious ... WHY do you want to insert a record in between two others?
What underlying business need are you trying to meet by doing that?
 
Back
Top