Hello,
I am trying to create an if and then formula, but am not having any luck. I am hoping someone can help with the syntax (or formula).
I have sales data which I want to identify which ones contain 2 specific values.
my formula is as follows:
if {Jobs.Site} = "WW" and
{Jobs.CustomerName} like "ABC*" then
"Accept"
So within my Jobs table, I have two things I want the report to look for and if they BOTH match, to use that result. It cannot be either one, it must be BOTH.
I am using CR 2008 and SQL database.
Thank you
I am trying to create an if and then formula, but am not having any luck. I am hoping someone can help with the syntax (or formula).
I have sales data which I want to identify which ones contain 2 specific values.
my formula is as follows:
if {Jobs.Site} = "WW" and
{Jobs.CustomerName} like "ABC*" then
"Accept"
So within my Jobs table, I have two things I want the report to look for and if they BOTH match, to use that result. It cannot be either one, it must be BOTH.
I am using CR 2008 and SQL database.
Thank you