At 21:03 05/03/2015 +0000, Vince Bonly wrote:
OKay! Have learned that table editing must be initiated via a right-click drop-down menu on the highlighted name of table, rather than attempting to use the menu-bar's "Edit" tab. I knew it was a simple solution.
That's not true: you can always use the menus. There are two things you might mean by "editing": modifying the table design (which is what you originally asked about - adding another field to an existing table) and editing the data the table contains.
o To modify the table design, you can use Edit in the context (right-click) menu, but you can indeed get to the same Table Design view via Edit | Edit... .
o To modify a table's data, you need Table Data View instead. You can double-click the icon, use Open in the context menu, or go to Edit | Open Database Object... .
My next task is to be able to insert a row between two already existing rows; is this possible, rather than the added row being located at the bottom of the table, i,e., last field? I have managed to add several new fields; however, it seems that these must always be appended following the presently last field within the table. Hmm.
The order of records in the table display in a database shouldn't matter. The way you use a database is not by examining tables but through queries, forms, or reports. The displays you actually see should not depend on the order of records in any table, I think.
If it helps, you can reorder records in a table using the sort facility. If sorting on existing fields cannot produce the order you require, you could add an additional field to indicate the order and then sort on that. But, as I say, I don't think you should particularly want to do this.
I trust this helps. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
