Is there anything wrong with this? If my "If" condition only contains one of the fields, things work fine, but using the "and" with two fields doesn't seem to work. I am probably writing this wrong, but it returns no errors. Also I cannot seem to find any set of rules for using "and", any hard rules I should know?
If IsNull ({#RTotal0}) and IsNull ({#RTotal1}) Then
{#RTotal2} + {Cabinets.CustomPrice}
Else
{#RTotal0} + {#RTotal1} + {#RTotal2} + {Cabinets.CustomPrice}
Thanks for the help,
Mike