Cross tab formula

Hi guys,

I am a Crystal beginner *trying* to make a cross tab formula work.

The db has 2 fields which hold the similar data.
I want to do something like:

If {field1} like "A*" or if {field2} like "A*"
then etc etc

But it is not letting me - it only recognises the first part of the if statement
So, any ideas why thats happening?
Cant you compare or pull from two fields in the same formula?
....and if you can't do it with an if/else then any ideas as to how I would do this?You don't want / need the 2nd "if"

If {field1} like "A*" or {field2} like "A*"
then etc etc