HELP ADDING RECORDS

[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

 

[Duane Hookom]

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.

 

[Jeff Boyce]

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?