Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .