Donate SIGN UP

Access 97 reports & query writing

Avatar Image
PeteWallace | 14:24 Tue 10th Jul 2001 | Technology
1 Answers
I have created a simple contacts database in MS Access 97. I want to write a query that will search through the records and retrieve contacts with a specific job role. When the query is run I would like to present the user with a list of job roles. The user could then click on the role they are interested in. they should then be given a query/report showing the contact details of all people with that job role. How do I do this? I have queries that allow you to type in the required job role but this is not a good enough solution as it relies on the user knowing which job roles are in the database. Thanks you.
Gravatar

Answers

Only 1 answerrss feed

Best Answer

No best answer has yet been selected by PeteWallace. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Create a new query and choose SQL View from the View menu then type in "SELECT DISTINCT [Table1].[fieldname] FROM Table1;" substituting table1 for your contacts table and fieldname for you jobrole field. Then you create a query form that has a list box that gets it's data from your newly created query.

Only 1 answerrss feed

Do you know the answer?

Access 97 reports & query writing

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.