Criteria question

[aml5171]

Hi all,

I am looking to create a criteria parameter that would allow me to run a query and draw results of a few different products.

I have been using the statement " Like [Please enter product name] & "*" "

I was wondering if it is possible to use a join such as "or" to do that twice. So the user can type in two different product types and their respective data.

If more description/details are needed or if i should upload my database please let me know.

Any advice or suggestions are greatly appreciated. Thank you for your time.

 

[jdraw]

Can you give an example of a typical query?

You mention 2 products, but what if you need 3 or 4...?