Access - Mostrar filas con campos vacios

Buenas a todos,

He creado una consulta para que me muestre los registros de una tabla en función a los valores introducidos en el WHERE. Los valores los recoge de diferentes objetos de un formulario (cuadro de texto, cuadro combinado, etc.). Todo funciona perfectamente, el problema que tengo es que no muestra los campos vacíos, es decir, aquellos campos incluidos en el WHERE que dentro de la tabla no tienen información.

SELECT tblD3.*
FROM tblD3
WHERE (((tblD3.LS_Number)>=IIf(IsNull(Forms!Delta3!IdEmpDes),tblD3!LS_Number,Forms!Delta3!IdEmpDes) And (tblD3.LS_Number)<=IIf(IsNull(Forms!Delta3!IdEmpHas),tblD3!LS_Number,Forms!Delta3!IdEmpHas)) AND ((tblD3.BUSINESS_IN_CHARGE)=IIf(IsNull(Forms!Delta3!lstresponsable),tblD3!BUSINESS_IN_CHARGE,Forms!Delta3!lstresponsable)) And ((tblD3.MSN)>=IIf(IsNull(Forms!Delta3!msndes),tblD3!MSN,Forms!Delta3!msndes) And (tblD3.MSN)<=IIf(IsNull(Forms!Delta3!msnasc),tblD3!MSN,Forms!Delta3!msnasc)) And ((tblD3.WORK_ORDER)=IIf(IsNull(Forms!Delta3!ApeDes),tblD3!WORK_ORDER,Forms!Delta3!ApeDes)) And ((tblD3.ORIGIN)=IIf(IsNull(Forms!Delta3!txtorigen),tblD3!ORIGIN,Forms!Delta3!txtorigen)) And ((tblD3.TEST_IMPACT)=IIf(IsNull(Forms!Delta3!txttest),tblD3!TEST_IMPACT,Forms!Delta3!txttest)) And ((tblD3.VBVU)=IIf(IsNull(Forms!Delta3!txtvbvu),tblD3!VBVU,Forms!Delta3!txtvbvu)) And ((tblD3.KIT_REF)=IIf(IsNull(Forms!Delta3!txtkit),tblD3!KIT_REF,Forms!Delta3!txtkit)) And ((tblD3.JOBCARD_REF)=IIf(IsNull(Forms!Delta3!txtjobcard),tblD3!JOBCARD_REF,Forms!Delta3!txtjobcard)) And ((tblD3.HAG_PRIORITY)=IIf(IsNull(Forms!Delta3!txthag),tblD3!HAG_PRIORITY,Forms!Delta3!txthag)) And ((tblD3.STATUS)=IIf(IsNull(Forms!Delta3!txtstatus),tblD3!STATUS,Forms!Delta3!txtstatus)) And ((tblD3.OBSERVATIONS)=IIf(IsNull(Forms!Delta3!txtobs),tblD3!OBSERVATIONS,Forms!Delta3!txtobs)) And ((tblD3.MANUFACTURER)=IIf(IsNull(Forms!Delta3!txtmanufac),tblD3!MANUFACTURER,Forms!Delta3!txtmanufac)) And ((tblD3.ENGINEERING_DEADLINE)=IIf(IsNull(Forms!Delta3!txteng),tblD3!ENGINEERING_DEADLINE,Forms!Delta3!txteng)) And ((tblD3.LS_FAL)=IIf(IsNull(Forms!Delta3!txtfal),tblD3!LS_FAL,Forms!Delta3!txtfal)));

Agradecería vuestra ayuda.

Hola,

En sql en oracle hay un comando llamado decode.

busca si hay para access algo así.

Básicamente es como un if
por ejemplo
decode(variables,isnull,0,variable) = variable_comparativa

Saludos
José Luis