Terry said:
Does anyone know how to insert a row in an access table?
I would really appreciate an answer to my question -
cannot find it in help - maybe it can't be done !!!!
When entering records directly into a Datasheet (not recommended) ALL
insertions occur at the bottom of the sheet in the new row position.
Tables are by definition unordered so there is no facility for inserting a
row anywhere in a datasheet except at the bottom. If you use a query,
form, or report that applies an explicit sort on the data then the new rows
will appear wherever is appropriate as defined by that sort. This does not
require that they be physically located at that ordinal position in the
table, which in a database has no real meaning anyway.
