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.
|