change results based on a value

M

mccloud

I have a website which is pulling data from an access query linked to a SQL
database. I'm able to pull live data from our inventory and display on the
web.
My issue: When I pull inventory data with 0 onhand I what to change this
value to say call. I know there may be an issue with numeric/alpha but where
do start. I thought about creating a new query that will look for zero and
input "Call" Is this the best way to handle our is there a better approach.

Thanks for your help.
 
E

elwin

You could use an immediate if in an expression, but the expression name will
need to be different. Good luck.

MyQuantity: IIf([Quantity]=0,'Call',[Quantity])
 
Top