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?
8/22/2022 - Mon
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!