Use of and/ or functions

[ckorrol]

As a relative novice, I would like to request help.

What is the syntax of AND/OR functions? I am unable to find this in the help directory.

crkorrol

[Fitch]

When you do a Find, use New Request for OR (State: Oregon OR State: Washington);

enter data in multiple fields in the same request for AND (State: Oregon AND Last Name: Smith).

http://www.filemaker.com/help/03-Finding%20sorting10.html

[Lee Smith]

Your question is pretty vague.

Look at the Online Help (available with FileMaker open) for

Contents > Creating a database > Working with formulas and functions > Using operators in formulas

If this doesn't address your question, then explain what you are trying to do.

HTH

Lee

[Fitch]

Oh yeah, that's true, he might be talking about calculations. My first thought was that he was trying to do something resembling an SQL query.

[ckorrol]

Sorry to be so vague.

What I'm trying to do is to create a calculated field, the result of which depends on two conditions being true.

In words, If condition1 AND condition2 are both true, then RESULT1, ELSE RESULT2

I hope this clarifies the problem.

Your attention is appreciated

C R Korrol

[Lee Smith]

Without more information as to what Condition1, and 2 are, and what Result1, and 2 are, Maybe.

Case (YourField= "condition1"; "RESULT1"; "RESULT2) note, I have placed the condition and results in quotes, as I'm not sure what are fields and what are text. Remove quotes for those that are fields

When posting a question to the Forum, please use real Fields, layouts, TOs, etc., and not hypothetical ones. You will get faster and clear answers, and we won't have to go through the pulling teeth to get enough information, in order to help you..

HTH

Lee

Edited February 14, 2008 by Guest

[The Shadow]

if (condition1 and condition2; result1; result2 )

[ckorrol]

Sorry about the vagueness, but I didn't know the rules.

In any event, I've been able to solve the problem on my own.

I appreciate all of the help everyone was trying to provide.

Thanks to all.

ckorrol