Inserting a new Record.

D

Denzil Hathway

It wont take you long to realize that I don't know much about Access. In
Access 2000, in an unsorted database, in Table view, how do you add a new
record and place it exactly where you want it to go?

From the Menu Bar, using Insert/New Record, the new record is placed at the
end of a pre-existing data list. When I cut or copy that and try to insert
into the series of records already there by highlighting the first column
and "Pasting" it replaces the line I highlight.

How can I insert that new record into the pre-existing unsorted list, or
create it in the spot where I want it to go in the first place? Help files
are silent on how to move individual records around.

Can anyone help, in simple terms ... I'm new? Thanks, Denzil.
 
L

Larry Linson

By definition, Records in relational database Tables are _unordered_. You
choose some Field, or Fields, on which you want to sort and retrieve them
with a Query that specifies those Fields. There is a very nice, easy to use
Query Builder that is a graphic user interface for building Queries without
having to become an expert in SQL.

Now, all that said, Access has to display the Records in _some_ order, and
that is usually determined by the Fields identified as the Primary Key. So,
if you can choose a Field that determines the order in which you usually
want to see the Record, and include it in the Primary Key, just clicking
View | Refresh after entering a new Record may accomplish what you want.
But, the CAVEAT is, Records are by definition unordered so you cannot count
on a specific order unless you use a Query to view them.

Larry Linson
Microsoft Access MVP
 
Top