Skip to Content
0
Former Member
Jan 12, 2012 at 09:21 PM

If And formula

61 Views

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 😊