Hi All

I'm declaring a global variable and getting the above error message

Dim sql1 As String
sql1 = "(TO>#" & Format(Date, "mm/dd/yyyy") & "# or TO IS null)"
Any help will be much appreciated.

Thanks