Access 2013 Query

[Mac1206]

How do I bring back all values for Fld_Demand in Table_A but if the value = "WR Other" bring that back As Misc.

FLD_Demand

CHQ

HC

MC

WR Other

SubHC

Plate

<colgroup><col></colgroup><tbody>
</tbody>

RESULT of Query <colgroup><col></colgroup><tbody> </tbody> <tbody> </tbody> Should Be: FLD_Demand CHQ HC MC Misc SubHC Plate <colgroup><col></colgroup><tbody> </tbody>

<tbody>
</tbody>

 

[Joe4]

Use a calculated field instead in your query to return this field instead, i.e.

New_FLD_Demand: IIF([FLD_Demand]="WR Other","Misc",[FLD_Demand])

 

[Mac1206]

Use a calculated field instead in your query to return this field instead, i.e.

New_FLD_Demand: IIF([FLD_Demand]="WR Other","Misc",[FLD_Demand])

Thanks Joe and have a wonderful filled weekend...

 

[Joe4]

You are welcome!