Hi,
I'm trying to understand why this is not working for me..
I'm using Access2000 database and ADO Object to show data over datagrid.
What I'm acually trying to do is to filter data according to the SAME criteria but on 5 different fields (some of the fields might contain a null value) named CRem1, CRem2 etc. - something like this:
BTW, I'm not in the US so there is no problem with the date format.. ;-)
Would appreciate any help solving this annoying problem!!
Thanks,
Yoav
I'm trying to understand why this is not working for me..
I'm using Access2000 database and ADO Object to show data over datagrid.
What I'm acually trying to do is to filter data according to the SAME criteria but on 5 different fields (some of the fields might contain a null value) named CRem1, CRem2 etc. - something like this:
Code:
"SELECT * FROM Data WHERE [CRem1] LIKE '1%' OR [CRem2] LIKE '1%' OR [CRem3] LIKE '1%' OR [CRem4] LIKE '1%' OR [CRem5] LIKE '1%' AND Date >= #28/08/2006 00:00:01# AND Date <= #29/08/2006 23:59:59#"
Adodc1.Refresh
Adodc1.Recordset.Filter = sSql
Would appreciate any help solving this annoying problem!!
Thanks,
Yoav