Manipulate output display based on other value

B

Bill

This is probably going to sound like a strange request but
here's the situation:
We have an inventory list with ProductName and NonStdInstr
as fields. When I run a query or report, I would like to
append the ProductName with an asterisk if NonStdInstr is
not Null. Is there a way to do that? I'm not much of a
programmer so detail or explanations are greatly
appreciated.
 
J

John Spencer (MVP)

Add a calculated field to your query.

Field: ProdNamePlus: [ProductName] & IIF([NonStdInstr] Is Not Null,"*","")
Table: <<Blank>>
 
Top