I do have following code:
strSQL = "SELECT IQ " & _
"FROM dbo_tblStatistikTmp_sb_Land WHERE ((Land)='VC') "
.Value = CurrentProject.Connection.Execute(strSQL)(0)
But as in some events, there will be even no recordset in the table that matches 'VC' for example, it gives back NULL for .Item which this can't handle. I read through a lot of NULL questions here and tried but didn't solve my issue. Any idea how to fix?