sorting with auto numbering

[Seapeace]

I have a table with a column that is auto numbered. Is there a way to turn
off the auto numbering so I can sort it without the numbers disappearing.

 

[Al Campagna]

Seapeace
There's something wrong here... an autonumber field can be sorted on,
just like any numeric field.
What do you mean by that. Please describe your autonumber field, your
table, and what you mean by "disappears."

Also... it's best not to work in your table. Create a query, or even
better, a form to view, edit add, delete to your table.
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[John W. Vinson]

I have a table with a column that is auto numbered. Is there a way to turn
off the auto numbering so I can sort it without the numbers disappearing.

You can't "sort your table".

A table is an unordered "bucket" of records. It has no defined order!

If you want to see records in a particular order, create a Query based on the
table; specify a sort on one (or two, or ten) fields in the query; and use
that Query as the basis of a Form to display the data.

Table datasheets are not designed for viewing or editing data. This is just
one of many issues with them.

 

[De Jager]

I have a table with a column that is auto numbered. Is there a way to turn
off the auto numbering so I can sort it without the numbers disappearing.