How do I insert new recordset in the middle of a table?

O

OM

I'm really new to Access.
I want to insert a new recordset into the middle of an existing table.
I thought that this would be simple to do!
I thouhgt it would be just like Excel.
But apparently not!

How do I insert into the middle?

Thanks.


OM
 
D

Dan Artuso

Hi,
You can't. The data in tables is in no particular order.
This is the way of relational databases.
If you want the data to appear in order when viewed, you sort it within
the query.

Select * From yourTable ORDER BY whateverFieldYouWant
 
Top