MS Access & Queries

Question

Looking for a bit of help for an Access/Query question pertaining to a homework assignment that has 6 separate questions. I have completed all but one. The assignment wants me to do the following query.

The name, unit price, and quantity ordered for all products purchased by a customer whose id is entered from the keyboard.

Is there a function I'm overlooking for the ID entity criteria? I've looked and searched but cannot find how to add that part into the query. Thanks in advance for any help.

Make the ID a parameter to the query. Read more here and here — D Stanley
– D Stanley, Commented Jan 22, 2014 at 15:51

D Stanley · Accepted Answer · 2014-01-22 15:52:33Z

2

You can accomplish this by making the ID criteria a parameter. Access will then pop up an input form that lets you enter the value of the parameter.

You can read more here and here.

answered Jan 22, 2014 at 15:52

D Stanley

153k12 gold badges190 silver badges257 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

allendks45 Over a year ago

That was the trick. Made the ID a parameter and when prompted enter the text and it populates with the information. Much appreciated...learned something new today.

Collectives™ on Stack Overflow

MS Access & Queries

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related