HELP! Simple sort order in a report (Alpha vs. KeyID)

[Guest]

USING Access 2003. I am trying to generate a report that is sorted by the
AlphaName, not the KeyID. I have a list of names that keeps sorting in the
order of the table KeyID field, and not by the actual alphaname. I am sure
it is a simple solution, but I just can't get it right. Please help!

Also, how do I reset the AutoNumber field in a table. I have followed the
instructions on Help (using a Query to Append To), but everytime I do it, it
shows "0 records added." What am I doing wrong?

Please help!

Thanks.

 

[Guest]

Hi David,

Alright, two parts to this one...

(1) Sort Order - you can change the sort order in the query. You can also
set the sort order in the Report by clicking on Sorting and Grouping and
selecting AlphaName from the list.

(2) Resetting Autonumbers... If you mean resetting it to 0, you need to
delete all items from your table then compact and repair your database. If
you need a number other than 0, you will need to reset it to 0 as above, then
insert X-1 records into the table, where X is the number you want to commence
with. Delete all bar the last record, compact adn repair, then delete the
last record. Do NOT compact and repair again until you have added the first
of your "real" records, or it will reset to 0 again.

Hope this helps.

Damian.

 

[Duane Hookom]

Sounds like you created a lookup field in a table. Do yourself a favor and
read about the evils http://www.mvps.org/access/lookupfields.htm.

If you want to display some text, you need to include the field that
actually has stored the text you want to display.

Also, why worry about the value of an autonumber? Its accepted purpose is to
be a unique, primary key. I rarely allow my users to even see these values.