By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,454 Members | 2,633 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,454 IT Pros & Developers. It's quick & easy.

beginner with autonumber problem

P: n/a
hello all,

i'm a beginner to access and i'm having trouble with autonumbers.

basically i have a list of restaraunts in a table. they are sorted ascending
by autonumber (1 to 283) although i would like to browse the form in
alphabetical order, but instead it goes in order of autonumber which jumbles
the list of restaraunts so they are not in alphabetical order.

i would appreciate any help!

thanks in advance

asif
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Create a query and sort on Name. Use the query wherever you would otherwise
have used the table.

For what it's worth, you shouldn't be working directly with the table (or
query) anyhow: you should always use a form.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"asif" <as**********@googlemail.com> wrote in message
news:8h*****************@fe1.news.blueyonder.co.uk ...
hello all,

i'm a beginner to access and i'm having trouble with autonumbers.

basically i have a list of restaraunts in a table. they are sorted
ascending
by autonumber (1 to 283) although i would like to browse the form in
alphabetical order, but instead it goes in order of autonumber which
jumbles
the list of restaraunts so they are not in alphabetical order.

i would appreciate any help!

thanks in advance

asif

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.