SQL转Access问题,高手请看看(50分)

SQL:
'select 0 as iYear, 0 as iCourse, '' '' as Code, ' +
'cast(null as int) as CredNo, cast(null as datetime) as CredDate, cast(null as int) as fenluno, ' +
QuotedStr(sCode) + ' as subjcode, subjname as brief, sum(debit) as debit, sum(credit) as credit, 1 as credtypeid, ' +
'subjname, sum(amount) as amount, balac, direction, balac as Define ' +
'from TvwCred where 1=1 '

Access :
怎样把 'cast(null as int) ,cast(null as datetime) as CredDate 等转为ACCESS支持的?? CInt , CDate都不支持Null型啊

用iif,你去查这个帮助就知道了.

好久没有上来了
用iif怎样处理??? 给出SQl语句看看

接受答案了.