Inserting a new Record.

  • Thread starter Thread starter Denzil Hathway
  • Start date Start date
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.
 
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
 
Back
Top