Here's one way but not using SQL, create a form using the wizard based on your contacts table and the fields that you want your query to look up, convert the boxes into combo boxes so that they are containing relevant data, then point your query at the combo box and form for the information.
WHERE ((Contacts.Category) Like [forms]![contactsearchform]![Comboboxname]);
I have reliesed that you are unable to make a query in SQL with a built in combo box. So from your idea and others I have made a form with the combo box and the query compares the data in the Contacts.category with the data in the new form "Choose Category".
WHERE (([Contacts].[Category]) Like [forms]![Choose Category]![Choose Category]);
Now as you know when you want the query to run you click the "Preview phone no" button which opens the "Choose Category" form where you select from the combo box the category that you want the report to create. I have made a button on this "Choose Category" form where it then opens the Form "Phone numbers by category". This is now running great.
I will now be able to use this concept with the Birthday Report.