Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Create a query using all the fields from the Customers table that will show those customers who have purchased a product with the Product ID 2. Save the query as Product and close the query.

How can I do it?

share|improve this question
Welcome to Superuser, Warren. Can you please edit your question with a little more detail? What version of Access are you using? What have you tried so far? – CharlieRB Feb 16 '12 at 13:53

NOTE: This may be slightly different depending on what version you are using.

Using the query wizard, select the Customer Table then use the >> to add all fields. Use details and then Name it what you want. Before you finish select the option to modify the query. When the query opens, place a 2 in the criteria for Product ID. Save the query and run it to see that it does what you like.

If you want to learn more about making queries in Access, here is some free training from Microsoft.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.