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.


[TABLE="width: 85"]
<colgroup><col></colgroup><tbody>[TR]
[TD]FLD_Demand[/TD]
[/TR]
[TR]
[TD]CHQ[/TD]
[/TR]
[TR]
[TD]HC[/TD]
[/TR]
[TR]
[TD]MC[/TD]
[/TR]
[TR]
[TD]WR Other[/TD]
[/TR]
[TR]
[TD]SubHC[/TD]
[/TR]
[TR]
[TD]Plate[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 341"]
<tbody>[TR]
[TD="colspan: 5"][TABLE="width: 85"]
<colgroup><col></colgroup><tbody>[TR]
[TD][TABLE="width: 341"]
<tbody>[TR]
[TD="colspan: 5"][TABLE="width: 85"]
<colgroup><col></colgroup><tbody>[TR]
[TD]RESULT of Query [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
Should Be:[/TD]
[/TR]
[TR]
[TD]FLD_Demand[/TD]
[/TR]
[TR]
[TD]CHQ[/TD]
[/TR]
[TR]
[TD]HC[/TD]
[/TR]
[TR]
[TD]MC[/TD]
[/TR]
[TR]
[TD]Misc[/TD]
[/TR]
[TR]
[TD]SubHC[/TD]
[/TR]
[TR]
[TD]Plate[/TD]
[/TR]
</tbody>[/TABLE]



[/TD]
[/TR]
</tbody>[/TABLE]

 

[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!