ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using Query in Excel (https://www.excelbanter.com/excel-programming/406665-using-query-excel.html)

Tim Hoyle

Using Query in Excel
 
I am new to using queries.

I am trying to edit a criteria item in a query by inputting a paramenter
into excel. This works fine for me when just entering a single criteria
item, but it won't allow me to use any operators, such as "OR", "<", In not
Null, etc. Why will these operators work when I am in the query application,
but do not work when entered into excel as a parameter. Am I using the wrong
syntax?

I appreciate any help.

Thanks.


All times are GMT +1. The time now is 01:39 PM.

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