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

  • Thread starter Thread starter OM
  • Start date Start date
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
 
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
 
Back
Top