SQL Query vs MS Access

[John]

I have the MS access query below which uses an IIF statement to put a value
in either the Owned Pallets or Rented Pallets field, how do I do this in SQL
?? ...

SELECT KC_COPA1.[Posting date], KC_COPA1.SKUCod e, KC_COPA1.HierLe vel3Code,
KC_COPA1.HierLe vel5Code, KC_COPA1.LineNo , KC_COPA1.EndMar ket,
KC_COPA1.Dispen ser, format(Sum(KC_C OPA1.HA),"0.000 0000000") AS Handling,
format(Sum(KC_C OPA1.ST),"0.000 0000000") AS Storage,
format(Sum(KC_C OPA1.PF),"0.000 0000000") AS [Primary Freight],
format(Sum(KC_C OPA1.IR),"0.000 0000000") AS [InterRegion Freight],
Format(Sum((IIf (KC_COPA1!MILLP AL="O",[MillPA],0)+IIf(KC_COPA 1!RDC1PAL="O",[R
DC1PA],0)+IIf(KC_COPA 1!RDC2PAL="O",[RDC2PA],0))),"0.000000 0000") AS [Pallets
Owned], Format(Sum(KC_C OPA1.SACost),"0 .0000000000") AS SA,
Format(Sum((IIf (KC_COPA1!MILLP AL="R",[MillPA],0)+IIf(KC_COPA 1!RDC1PAL="R",[R
DC1PA],0)+IIf(KC_COPA 1!RDC2PAL="R",[RDC2PA],0))),"0.000000 0000") AS [Pallets
Rented], Format(Sum(KC_C OPA1.ODCost),"0 .0000000000") AS Other,
Format(Sum(KC_C OPA1.DA),"0.000 0000000") AS Admin,
Format(Sum(KC_C OPA1.CDPCost)," 0.0000000000") AS SumOfCDPCost INTO [R3
Results_Rev]
FROM KC_COPA1
GROUP BY KC_COPA1.[Posting date], KC_COPA1.SKUCod e, KC_COPA1.HierLe vel3Code,
KC_COPA1.HierLe vel5Code, KC_COPA1.LineNo , KC_COPA1.EndMar ket,
KC_COPA1.Dispen ser;


Thanks, John

[Yannick Turgeon]

Re: SQL Query vs MS Access

> I have the MS access query below which uses an IIF statement to put a
value[color=blue]
> in either the Owned Pallets or Rented Pallets field, how do I do this in[/color]
SQL[color=blue]
> ?? ...[/color]

IIf(expr, truepart, falsepart) = CASE WHEN expr THEN truepart ELSE falsepart
END

Yannick