Append Query Auto-Number

[Guest]

Hi, I have two questions in regard to Append Query.

1. After I appended the new data to my database, can I control where the
data goes? In other words, I like the data to be appended on the bottom of
my main database table instead of on the top or vice versa.

2. After the append query is complete, the database table shows some weired
looking number in the autonumber column of my main database (i.e 15550,
15551...etc) rather than giving me the correct autonumber sequence.

Please help. Thanks K.

 

[Jeff Boyce]

Access stores table data in big buckets, without any inherent (or at least,
without any perceptible) order. The only way you can get order is to impose
it yourself, by adding a field on which you wish to have the data sorted.

If you are looking at the top/bottom of tables for your data, you are
missing the greatly-expanded capabilities of forms. Tables store data,
forms display it. Use forms to look for data.

If you'd like to see the data in a table in some sorted order, create a
query and sort by some field.

On the topic of "Autonumber sequence"...

If, by "Autonumber", you mean the same thing that Access does (i.e., an
arbitrary, generally unique row identifier), then it should not matter what
number Access assigns. Autonumbers (Access Autonumbers) are not necessarily
suitable for human consumption.

If you wish to have a controllable sequence number on your records/rows,
you'll have to add a field to hold this number, and you'll have to create
your own routine for generating this number. You can find ideas on doing
this at the mvps.org/access website -- called "custom autonumber".

Regards

Jeff Boyce
Microsoft Office/Access MVP

"E-mail report using Lotus Notes rather t"