Hello Community,
I want to know if the proposed syntax is right?
As a whole, only rows 1, 2 and 3 work for me, but rows 4 and 5 do not filter me.
If I raise individually 3, 4 and 5, the filter works for me.
Hi again @fgonzalez515
I want you to take a closer look.
Note the use of brackets.”( )”.
SELECT *
FROM [Sheet1$]
WHERE [Date] between #2014-01-01# and #2014-04-30#
AND ([Country] ='Canada' OR [Country]='Mexico')
AND([Product]='Carretera' OR [Product]='Amarilla' OR [Product]='Montana');
Hi @ZS440,
I tried this
But I also get other results, not those of the syntax
But in my excel it managed to filter my syntax
Some help