Solved Query date or is null not working

Number11

Member
Local time
Today, 19:27
Joined
Jan 29, 2020
Messages
623
So i am trying to bring back in a query the results of all call made after another date field or is null, but its only bring back null records, even though we do have calls with dates i am using

"Contact_Date"
>=[Start_Date] Or is null
 
The full syntax in a SQL statement would be

[Contact_Date] >=[Start_Date] Or [Contact_Date] Is Null
 
Thank you that did the job :)
 

Users who are viewing this thread

Back
Top Bottom