empty value of ms access, asp, vbscript

How we can recognize an empty value of ms access field.

suppose :
[CODE]Dim empVal, empVal1, num
num = 0
empVal = Recordset.Fields.Item("subj").Value
empVal1  = Recordset.Fields.Item("org").Value[/CODE]
here empVal = "" and empVal1 = "" i. e. in the database there are no value i.e. empty
so if i wrote
[CODE]If ( (empVal = "") AND (empVal = "") ) Then
 num = num + 1
 response.write num
 response num
end if [/CODE]
here value should show "1"
But it is not entering within the if condition.
So, how can we evaluate the value of empty
 

 

Hi Dilruba,

use the VBScript Docs to read about IsNull().