Parameter querey

[alguzman]

Hi, can anyone tell me if there is a way to choose more than one parameter on a parameter querey. I made a products list for a convention company and then made a product search parameter querey where the attendee enters one product number in and a report bound to the querey automatcally prints giving company name, product name and company location in exhibit hall. That all works fine using macros. What I would like is to somehow have two, three or four choices on the parameter querey and then have my print out give information on all four products at the same time. The way it is set up now you have to do each product one at a time. Any help out there would be great. Al

 

[jwindon]

You will add three more unbound controls to the form. In query design, under [ProductID] criteria, you will say this:

=[Forms!ChoiceForm![ProductID] OR (this is on the next line down!)
=Forms![ChoiceForm]![UnboundFieldName1] OR (another line down)
=Forms![ChoiceForm]![UnboundFieldName2]

etc...

Then base your report off the query.
There is more than one way to skin a cat, this method will work exspecially if your productID's chosen are not ones that would be of sequential order.

Hope that helps.

 

[Jack Cowley]

Does your cat know you speak that way? I used that phrase here a couple of times and paid a hefty price because of it. Even Mr. Mauers (a cat) was upset with me....

 

[alguzman]

Thnaks guys I will give it a shot. Al

 

[jwindon]

Jack: My "baby girl" cat knows I wouldn't harm a sliver of fur on her back! You know that in Kentucky, sayings are a big thing....ever hear " Full as a tick? " after a big meal? I think a couple of my "native" friends could write a book. I'm a yankee myself, so I only use a few passed down from my family.

Anyway, I hope that alguzman got enough information.