I never tried this, so having a few issues, i copied the sample but still get error on the unbound control with 0.00;[red]"Status";[red]"Stock"My apologies CJ_London. Works great
please help, no idea what to do, neither of my attempts are working
not
# =iff([OTR5C QRY]![Stock Avilable]>[OTR5C QRY]![Reqmt Qty1],"Stock") #
# =iff([OTR5C QRY]![Stock Avilable]<[OTR5C QRY]![Reqmt Qty1],"Shortage") #
nor 0.00;[red]"Status";[red]"Stock"
also not sure how to change 0.00;[red]"Status";[red]"Stock" if i need to compare from another field
i get below error