How do you insert (not add) information in the access database

A

amen572001

I am working in a very simple access data base I have the auto numbering on
this I need to insert several lines in different spots with information I see
on the toobar where you can delete a line how do you insert a line? Thanks
for your help

amen572001
 
J

John Vinson

I am working in a very simple access data base I have the auto numbering on
this I need to insert several lines in different spots with information I see
on the toobar where you can delete a line how do you insert a line? Thanks
for your help

amen572001
Click to expand...

Did you see Joseph's and my responses this morning?

Again:

A database

IS NOT A SPREADSHEET.

You should not, indeed *cannot*, "insert" a row in a table, any more
than you would "insert" another golf ball into a bucket full of golf
balls. You just throw the new record into the table, just as you'ld
throw another golf ball into the bucket.

You are misunderstanding and misusing the program if you try to do
this.

Solution? Have a numeric field in your table; manually or
programatically set that field to the desired sort sequence. Use a
Query sorting by this field to display the data in order.

John W. Vinson[MVP]
 
Top