A-Z list in Access

[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

 

[Allen Browne]

For an example of how to do this, open the Northwind sample database, the
Customer Phone List form.

 

[John Vinson]

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