I have a query that pulls data from an external database. The query asks
the user for a repcode, year and month and it produces a list based on a
specific product code.

Unfortunately the query now has to say this product or this other
product. This means two lines in the query because of the OR criteria.

But now the query asks for the repcode, year and month twice, once for
each line.

Is there a way around this?