Answered You can hire a professional tutor to get the answer.
How do I create a query in Microsoft Access that references only one order?
How do I create a query in Microsoft Access that references only one order? Here is the question I have to answer:
The company is interested in knowing on which date order number 3020 was shipped. Use the Shipment table create a query that shows the ship date for order number 3020 and make certain the query contains the orderID. Name the query "Order 3020 Shipped" (without the quotes).
I know how to create the query and make it reference the shipment table and show the ship date and order ID. My problem is I can't figure out how to make this query ONLY show me order number 3020. It shows all of the ship dates and order ID's in the document. (about 3000 orders).
