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
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