BTW, each pair of {} needs to be the special fild braces that you can enter
using ctrl-F9. You can't use the ordinary {} keyboard characters.
--
Peter Jamieson
http://tips.pjmsn.me.uk
"Peter Jamieson" wrote in message
...
There are a few possible approaches, e.g. the "obvious" one:
{ IF {Criteria1} = x "{ IF { Criteria2} = y "{ the field you want }" "" }"
"" }
In some cases you may be able to combine the criteria in a useful way,
e.g.
{ IF "{Criteria1}{Criteria2 }" = "xy" "{ the field you want }" "" }
(that's a string concatenation, not a multiplication. In that case it
wouldn't be helpful if Criteria1 could be "xy" and Criteria2 could be "",
for example)
Or you can use a number of types of calculation, e.g.
{ IF {={ COMPARE { Criteria1} = x }+{ COMPARE { Criteria2 } = y } } = 2
"{ the field you want }" "" }
{ IF {=AND({ COMPARE { Criteria1} = x },{ COMPARE { Criteria2 } = y }) } =
1 "{ the field you want }" "" }
--
Peter Jamieson
http://tips.pjmsn.me.uk
"JoePineapples" wrote in message
...
Hi All
I can use the IF function for one criteria but is it possible to have two
criteria.
eg.
IF {Criteria1} = x AND {Criteria2} = y THEN Show Field
Any help would be much appreciated.