Conditional Formating?

[Number11]

I need to add a formula to a query to report as if data is found in one column write in a new column something like

Machine_SN	New Column
23GGGED11121212	BlueShark Brand

So machine_SN if its populated - say BlueShark Brand ?

 

[Gasman]

That is not conditional formatting?
Use an iif() function in the query.

 

[Pat Hartman]

I'm not sure how one value gets translated to the other. As Gasman suggested, you can do this with an IIf() but that is only rational if you have a very small set of values.

A better solution will probably be a lookup table that lists all the values that need to be translated and the result you want to see. Use a left join to this table if not all values will be found.