printing either/or

[JEB]

I am pulling 4 fields from a from a database through a query.

They are:

qty_ship
qty_uom (unit of measure)
alt_qty_ship
alt_uom

The units vary - but an example would be CTNS as the primary and PCS as the alt.

If qty_shp has a value then alt_qty_ship is zero (not blank)

I want to print just the field that has a value and its coresponding UOM

Can I due this with IFF? I have not been able to make it work.

Is there another way?

Thanks,
Jeb

 

[boblarson]

You can set an expression in your query to be:

AltQtyShip: IIf([qty_shp]>0, 0, [alt_qty_ship])