423,680 Members | 2,439 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,680 IT Pros & Developers. It's quick & easy.

update access table to alphabetical order

P: 1
1. table with fields id, LastName, FirstName, Address, City, State.
2. New records added to table are place at the end in last row.
3. Is there a way after a period of time to rearrange the records in alphabetica order by last name without indexing. I wish to have the default table in alphabetical order by last name including all records at startup.
Feb 28 '14 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,272
Use a view when you want to see it in alphabetical order.
Feb 28 '14 #2

Post your reply

Sign in to post your reply or Sign up for a free account.