Replace query value "0.0.0.0" with alternate txt "HP Procurve"

[scouser]

Hi. I have a query that works OK. However I would like to replace a couple of records returned with an alternate value.

I would like to replace 0.0.0.0 with text "HP Procurve".

I have the following that is incorrect:

IP: IIf(="0.0.0.0"([qryDISPLAY_NWP_COMPUTER_SWITCH_MAPPING.IP]),"HP Procurve ",[qryDISPLAY_NWP_COMPUTER_SWITCH_MAPPING.IP])

Can any of you coding gurus assist?
Many Thanks,
Phil.

 

[ajetrumpet]

you have the first section switched around I think. Try this instead:

IP: IIf([qryDISPLAY_NWP_COMPUTER_SWITCH_MAPPING.IP]="0.0.0.0",
   "HP Procurve",[qryDISPLAY_NWP_COMPUTER_SWITCH_MAPPING.IP])

 

[scouser]

Perfect

Adam not only was that quick but also spot on, many thanks.
Phil.