？？？？？该怎么办

[ilovebcb2000]

我原来的sql语句是按照oracle的格式写的。现在老板要求作一个access的演示版，下面的这个sql语句该怎么写：
oracle:
SQLStr = "select nvl(XLGDKKX,0),nvl(JCDSL,0),nvl(SJJCDSL,0),nvl(MCYJSLB,''),nvl(BYQBHGNUM,0),nvl(GYKHBHGNUM,0) from PD_GDKKXFXYB where xlid=" & "'" & FX_LineID & "'" & " and qsrq=to_date(" & "'" & FX_BeginDate & "'" & ",'yyyy-mm-dd') and zzrq=to_date(" & "'" & FX_EndDate & "'" & ",'yyyy-mm-dd')"

求Access:格式下的写法（主要是对nvl函数的处理，access里怎样房子空值）

[ilovebcb2000]

多谢老兄，给分了

[changechange]

SQLStr = "select nz(XLGDKKX,0),nz(JCDSL,0),zn(SJJCDSL,0),nz(MCYJSLB,''),nz(BYQBHGNUM,0),nz(GYKHBHGNUM,0) from PD_GDKKXFXYB where xlid='" & FX_LineID & "' and qsrq=to_date(" & "'" & FX_BeginDate & "'" & ",'yyyy-mm-dd') and zzrq=to_date(" & "'" & FX_EndDate & "'" & ",'yyyy-mm-dd')"


to_date你自己改一下