Recent content by dyrueta

Like this ---? UPDATE tblRESULT AS RS INNER JOIN dbo_PRM_MASTER__EMPLOYEE AS EMP ON RS.EMPLOYEE = EMP.EMPLOYEE SET... iif(isNull(EMP.ADDRESS_2), RS.ADDRESS_2 = " ", RS.ADDRESS_2 = EMP.ADDRESS_2)...

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...

I've refined the query def to the point where the exact same text produces both the null and the not null recordset. Before the column selection refresh -- SELECT CHECKS.EMPLOYEE, Sum(TAXES.AMOUNT) AS EXEMPTION FROM dbo_PRT_CURRENT__CHECK AS CHECKS INNER JOIN dbo_PRT_CURRENT__CHECK_TAX AS...

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...

I feel studip now :) Thanks for the help!

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...