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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding new records via recordset 4
VBA - retrieve data on last create named range from previous inserted named range 0
Access Passing the value to a table 1
How to Populate Data from a table to another 0
APPEND QUERY USING A RECORDSET 1
Importing Text Files Into Access 1
Inserting a new record 1
How do I insert record into the table from recordset? 1

Back
Top