Adding records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way to add a record into the middle of a database without having
to add it at the end and then sort. I need to be able to manually add
records into the database, as though you would in excell, exactly where I
want it without having to use sort since not all of the data can/should be
sorted. Any thoughts?
 
Tables are unordered. If you need to Order records then you use a
query. You then need a way of defining that order.

A more specific description of your problem including descriptions of
the fields involved will get you a more specific answer.

Cheers,
Jason Lepack
 
First of all, you add records to a table. A database can have many tables.

Second tables have no set order. In theory you could open a table; look at
the records; close and reopen the table and all the records could be in a
completely different order.

The only way to maintain the order of records is to sort by a field or
fields. The sorting can be done in a query, form, or report, but there must
be some field which has data that can be sorted.

In short, you can NOT add a record in the middle of a table or query for
that matter. You might be able to simulate it in a form; however, unless the
record has something to sort on, there's no guarentee that the new record
will stay where you want.
 
It's a software inventory. If you are familiar with GIS software at all ESRI
puts out software that come in packs with multiple folders. I need to keep
each disk associated with each folder and then associated with each pack but
this software is the only kind that I need to track like this. I will need
an alphabetical listing of all software, but if I alphabetize the whole
querry it will split up my folders and packs.
 
Back
Top