locked
Creating calculated field in VS2005 Query Builder RRS feed

  • Question

  • Hi,
       I'm trying to convert this calculated field from Access DB to VS2005 Query Builder:
    Expr1: Sum(IIf(C.Service_Type="SR",Round(A.DIRECT_CARE_HOURS*F.SRpercent,2),Round(A.DIRECT_CARE_HOURS*F.NSRpercent,2)))

    I used this one:
    CASE WHEN C.Service_Type = 'SR' THEN A.DIRECT_CARE_HOURS * F.SRpercent ELSE A.DIRECT_CARE_HOURS * F.NSRpercent END AS Expr1

    eventhogh I get rid off the round function, I'm still getting error!! 
    How can I mimic the same statement...?? any one can help, I appreciate your time.
    Friday, April 17, 2009 6:29 PM

Answers