Solved Query date or is null not working (1 Viewer)

Number11

Member
Local time
Today, 17:16
Joined
Jan 29, 2020
Messages
607
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
 

Minty

AWF VIP
Local time
Today, 17:16
Joined
Jul 26, 2013
Messages
10,371
The full syntax in a SQL statement would be

[Contact_Date] >=[Start_Date] Or [Contact_Date] Is Null
 

Number11

Member
Local time
Today, 17:16
Joined
Jan 29, 2020
Messages
607
Thank you that did the job :)
 

Users who are viewing this thread

Top Bottom