I'm trying to recode this access code into sql but getting stocked with these IIF, please help:
--------------

SELECT M_accdi.wh_acc_no, (M_accdi.ACCRD_INT+M_accdi.dr_bal) AS Balance
, M_accdi.IntOnlyInd AS Int_Only_Ind
, IIF(M_accdi.REPAYMT_INTERVAL=3,4
,IIF(M_accdi.REPAYMT_INTERVAL=6,2
,IIF(M_accdi.REPAYMT_INTERVAL=7,52
,IIF(M_accdi.REPAYMT_INTERVAL=12,1
,IIF(M_accdi.REPAYMT_INTERVAL=14,26,12))))) AS Divisor
,((IIF(M_accdi.CNTRACT_MATURITY_DTE IS NULL,M_accdi.NXT_REPRICING_DTE
,M_accdi.CNTRACT_MATURITY_DTE)-#12/31/2012#)/365.25) AS Resid_Mat
, IIF(((IIF(M_accdi.CNTRACT_MATURITY_DTE IS NULL
,M_accdi.NXT_REPRICING_DTE,M_accdi.CNTRACT_MATURIT Y_DTE)-#12/31/2012#)/365.25)<=0,1,
CInt(IIF(M_accdi.REPAYMT_INTERVAL=3,4,IIF(M_accdi. REPAYMT_INTERVAL=6,2
,IIF(M_accdi.REPAYMT_INTERVAL=7,52,IIF(M_accdi.REP AYMT_INTERVAL=12,1
,IIF(M_accdi.REPAYMT_INTERVAL=14,26,12)))))*((IIF( M_accdi.CNTRACT_MATURITY_DTE IS NULL
,M_accdi.NXT_REPRICING_DTE,M_accdi.CNTRACT_MATURIT Y_DTE)-#12/31/2012#)/365.25)
)) AS Num_Payments, M_accdi.acc_dr_int_rte/100 AS acc_dr_int_rte
, M_accdi.repaymt_amt, M_accdi.Var_Ind, M_accdi.DEFAULT
FROM M_accdi;

-----------

Hello menssanvi,

Thank you for posting your question in the "Microsoft Access 2010 24-Hour Trainer" book forum. I see the code you have provided here and I'm wondering if you can send me the actual database so that I can take a look at the problem? Please let me know when you have a chance!

Best Regards,

__________________
Geoffrey L. Griffith
http://www.ImagineThought.com

Wrox Author of:
Microsoft Access 2010 24-Hour Trainer
Access 2010 Programmer's Reference
Access 2007 VBA Programmer's Reference

*** Please click the THANKS button (to the right) if this post helped you! *** ---------------------------------------------------------------------------------------------------------->

My first post - hope it works.
sounds like you may not understand the IIF(a,b,c) construct.
it is known as the inline If.
you can view it in builder in the query design part of access.
basically it says if(any condition,value if true,value if false)
complexity is added by nesting them.
iif(day of week = 6 or 7, "weekend", "weekday" ) [assuming that was right]
iif(dow=1,"mon",iif(dow=2,"tue",iif(dow=3,"wed", "thu onwards")))
anyway - you can replace that in SQL using CASE when then construct.

case dow when 1 then "mon"
when 2 then "tue"
when 3 then "wed"
else "something else"
end case

- I've forgotten the actual syntax and you may not need end case
test with just 2 nested conditions before you write it all.
good luck from
ozzzy