Manipulate output display based on other value

  • Thread starter Thread starter Bill
  • Start date Start date
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.
 
Add a calculated field to your query.

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

In the top row of a column in your query design, instead of just the field ProductName, put the
following:-
Expr1:[ProductName] & Iif(IsNull([NonStdInstr]),"","*")

This just alters the display, not the underlying data.

HTH
Andrew L.
 
Back
Top