I would much appreciate help on my problem.
I am retrieving data form Sage line 100 using an ODBC link.
One of the fields (columns) Is INVOICE_DATE and I need to select records when two criteria are matched.
Firstly when the INVOICE_DATE is greater than 3 days less than the current date
OR
Secondly when there is no INVOICE_DATE in the Sage file
I had hoped to achieve this using something like this in the MS Query grid
Field INVOICE_DATE
!st Criterion : DateDiff("d",date,INVOICE_DATE)<4
2nd Criterion :Is Null
My main suprise is that the 2nd criterion didn't work.
Nor did : ""
I have tried a whole range of ideas like the above but all end either as "Syntax error" or a message "Cant find column".
I have a work round by doing the selection in a worksheet, but this is an ineligant solution

I hope somebody can find the time to point me in the right direction
John S