A-Z list in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to be able to bring up all, for example companies that begin with the
letter 'A'. How do I set up an alphabetised index that allows the user to
pick a certain letter that then allows the user to search all companies
beginning with the chosen letter?

Thanks for your help
 
For an example of how to do this, open the Northwind sample database, the
Customer Phone List form.
 
I want to be able to bring up all, for example companies that begin with the
letter 'A'. How do I set up an alphabetised index that allows the user to
pick a certain letter that then allows the user to search all companies
beginning with the chosen letter?

Thanks for your help

An Index on the Company field will make the search faster, but it
otherwise stays in the background. Unlike xBase databases you don't
have to "do" anything with indexes.

Instead, create a Query based on your Companies table, with a
Criterion of

LIKE [Enter first letter of company name:] & "*"

This will translate to

LIKE "A*"

when the user types A, and will return Aardworks Ltd. through Azure
Skies Productions.


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top