Assign the IS NOT NULL to a variable

[miguel vasquez]

Anyone knows how to assign the a IS NOT NULL to a variable

strDept = "'is not null'" ******** THIS DOESN'T WORK **********

 

[KenHigg]

So you have a string variable and you want to set it to anything but null???

 

[RuralGuy]

But this will! - strDept = "is not null"
How about explaining what you are trying to accomplish.

 

[miguel vasquez]

I have a drop down in my form, so when I select All in my department Name, I want to assign is not null to a variable, because I have a SQL statement based on my variables, see below...Thanks in advance


If Me.DeptName <> "All" Then
strDept = "'" & Me.DeptName & "'"

ElseIf Me.DeptName = "All" Then
strDept = "'is not null'"

End If

strSQL = "Select * into ReportTable from MainTable Where (type =" & strRPT & " or type =" & strRPT1 & ") and (DepartmentName =" & strDept & ")"
DoCmd.RunSQL strSQL
DoCmd.OpenTable "ReportTable", acNormal, acEdit

 

[gemma-the-husky]

try setting strdept = "*", to see if that returns everything in your query?

 

[miguel vasquez]

I know that I need to assign a specific value to a variable. My question is can assign is not null to a variable. I am passing the value to a SQL statement.

I need help on this issue!!!!

 

[jeremypaule]

make an IF statement before the SQL?

IF not null then

 

[RuralGuy]

There are other issues with your current structure. Why not just create different strSQL depending on the value of Me.DeptName?