Adding AutoNumber Field

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I have an existing table that is sorted the way I want it
by using an advanced filter/sort. I want to add an
AutoNumber field to the table, but when I try, it doesnt
retain the sort that I have on the table. Any thoughts?

Scott
 
Scott

When you say "sorted the way I want with a filter/sort", do you mean the
table itself, or a query of the table? As a general practice, you're better
off NOT working directly in the table -- rather, use a form. If you need a
sort, use a query as the source of the form, and base the query on the
underlying table.

As another approach, have you considered setting an index on the table?
 
Back
Top