comparing fields

[kitty77]

I'm opening a report based on a certain criteria...

If [field1] = [Field2] And [Field3] = "Apple" And [Field4] = "Red"
Then it opens a unique report.

It works but not when I add them together like I am. It does not seem to like the = and together.

What am I doing wrong?

Thanks...

 

[Gasman]

Try

If ([field1] = [Field2]) And ([Field3] = "Apple") And ([Field4] = "Red")

 

[kitty77]

Bingo!!! That did it. Thank You.