Access 97 reports & query writing

[PeteWallace]

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.

[adeywilliams]

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.