I am trying to pull all records from REDBALLtbl where REDBALLtbl.CT (date) is between today and 7 days prior to today PLUS (AND) REDBALLtbl.TT (text) is NULL.
Am I supposed to have date delimiters in "#"... I tried it and got the same error. I get the missing operator in query expression. Highlighting the where clause. Is it the lack of text delimiters " ' " for ISNULL... do you use text delimiters when saying ISNULL?? I've tried it with and without... and get the same errors... so I'm not sure what the problem is.
Any help would be greatly appreciated.
A.J.
Code:
sevendaysql = "SELECT DISTINCT * FROM REDBALLtbl WHERE REDBALLtbl.CT = BETWEEN " & Format(DateDiff("d", 7, Now()), "dd-mmm-yy") & " AND " & Format(Now(), "dd-mmm-yy") & " AND REDBALLtbl.TT ISNULL)"
Am I supposed to have date delimiters in "#"... I tried it and got the same error. I get the missing operator in query expression. Highlighting the where clause. Is it the lack of text delimiters " ' " for ISNULL... do you use text delimiters when saying ISNULL?? I've tried it with and without... and get the same errors... so I'm not sure what the problem is.
Any help would be greatly appreciated.
A.J.