IF OR AND Statements

[ahuvas]

Hi

I think this is probably a basic statement but I can't seem to find what I am looking for...

How do I combined multiple OR statements in conjunction with an AND statement as follows:

If [Len(Field1 & "")=0 OR Len(Field2 & "")=0] AND Field 3 = "Something" AND Field 4 = "Something" Then...

I thought there I had to use a | symbol but I am not exactly sure?

Many thanks

 

[plog]

Parenthesis.

If (Len(Field1 & "")=0 OR Len(Field2 & "")=0) AND Field 3 = "Something" AND Field 4 = "Something"

 

[ahuvas]

Ahh, I didn't think parenthesis worked like that in Access. OK I will try this out and get back to you. Many thanks!