New rows in Access?

[skylark53]

Hi,

In the 'datasheet' view of Access, does anyone know how to insert a new row - at an arbitrary place, not at the end? I have searched help and feel quite gloomy that it isn't possible.

Cheers, Sky

Edited February 16, 2008 by skylark53

[Martin L]

i dont know why you want to do that but in access you always have to define a key, if you dont do that access will define a key by itself. Now if you have a row of numbers and you want to add one, for example you have 1,5,9,15,17 and you want to add 10 then just make it on the last row and sort it on the key or one any colum you want, save it and problem fixed i think... but my view is limited since i dont know your motivation of inserting a new record half way a table...

[stans4]

Hi,

In the 'datasheet' view of Access, does anyone know how to insert a new row - at an arbitrary place, not at the end? I have searched help and feel quite gloomy that it isn't possible.

Cheers, Sky

You're trying to do too much with a table. Tables are just buckets where you dump data. Queries are what you use to get the data into the desired order, you use sorting to do that. If you're just adding a record to a table, it'll always end up at the end in the table's datasheet. Add a sort-order field, just an integer, number your records in the order you want to see them, then sort the thing in a query using that field. You don't have to display the sort-order field, just use it to sort. One way to get entries in a combo box to display in a desired order.

Stan