Hello,
I'm trying to create a report that will show all customer parts/vendors that are shipping late. My current formula in Select Expert pulls all vendors but I'm trying to limit that to only vendors that have customers in the title. The formula listed below worked great until I added the Vendor Name field.
{POFOD.REV_DEL_DATE} <= {?DELIVERY DATE} and
{POFOD.BALANCE_DUE} > 0.00 and
{POFOD.PART_ID} <> "" and
{POFOM.VENDOR_NAME} like "CUSTOMER" <-How do I word this, so it pulls only Vendor with the word customer in it?
Thank you,
John
I'm trying to create a report that will show all customer parts/vendors that are shipping late. My current formula in Select Expert pulls all vendors but I'm trying to limit that to only vendors that have customers in the title. The formula listed below worked great until I added the Vendor Name field.
{POFOD.REV_DEL_DATE} <= {?DELIVERY DATE} and
{POFOD.BALANCE_DUE} > 0.00 and
{POFOD.PART_ID} <> "" and
{POFOM.VENDOR_NAME} like "CUSTOMER" <-How do I word this, so it pulls only Vendor with the word customer in it?
Thank you,
John