Conditional Formating?

Number11

Member
Local time
Today, 02:39
Joined
Jan 29, 2020
Messages
623
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_SNNew Column
23GGGED11121212BlueShark Brand

So machine_SN if its populated - say BlueShark Brand ?
 
That is not conditional formatting?
Use an iif() function in the query.
 
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.
 

Users who are viewing this thread

Back
Top Bottom