Search results

Hi All -- Is there any way to prevent an Update Query from completely failing if one or some of the fields in the source table are null? Example: Here's the SQL statement for the update Query: UPDATE tblRESULT AS RS INNER JOIN dbo_PRM_MASTER__EMPLOYEE AS EMP ON RS.EMPLOYEE = EMP.EMPLOYEE SET...

Hi All -- It seems as though identical queries are not producing identical results. The query below was produced by a QueryDef statement in VBA and results in a null recordset, or the error posted in my title: SELECT CHECKS.EMPLOYEE, Sum(TAXES.AMOUNT) AS EXEMPTION FROM dbo_PRT_CURRENT__CHECK...

Hi All -- Access newbie here, trying to write some very simple VBA code in DAO, with very little success. Newest reason to want to throw my laptop through a window is the result of run-time error 3606, which states that "query must have at least one destination field." Here's the code: Sub...