ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Inputing data twice into a Query (https://www.excelbanter.com/excel-programming/350007-inputing-data-twice-into-query.html)

Keith[_11_]

Inputing data twice into a Query
 
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?


All times are GMT +1. The time now is 05:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com