search multiple fields for results

[noneofyo]

hello,

i would like to find people who have voted in the last 3 elections. i have 4 fields named with a date. in that field is either n (did not vote), p (voted at polls) or a (voted absentee). how would i find folks who vote either absentee or at polls in 3 of 4 of these dates?

tnx for your help

[Lee Smith]

Why don't you update your profile so we know how best to answer your question. The link is on the Left under your handle in blue, "profile"

Is this data already in a FileMaker file.

Lee

[bruceR]

Sounds like a design problem. There should only be ONE date field; and a vote type.

[transpower]

Add a calculation field for the number of voters in the last three elections, voteNumber =

Let ( [ X2 = If ( f2 <> "N", 1, 0 ) ;

X3 = If ( f3 <> "N", 1, 0 ) ; X4 = If ( f4 <> "N", 1, 0 )] ;

X2 + X3 + X4

)

where the fi are the last three of your fields.

[-Queue-]

Or more simply, not PatternCount( f2 & f3 & f4; "n" )

Perform a find for 1 in this field.

[Ugo DI LUCA]

Well,

Just one other idea with 7.

I'd assume one day you'd need to see those who voted on 2 of 4, or for all of them...

The Let( ) would let you use this parameter too, but you can also do it with a relationship.

Create a relation with a new Table Occurrence, using :

- a global field

matching a calc

n_voteAttendance = PatternCount(f1&f2&f3&f4;"n")

and set this relationship option with the ">" sign.

Now, you can view the result in a portal, and dynamically switch from one result to the other.

I'd agree with Bruce that your design isn't the best here though.

[transpower]

Or: 3 - PatternCount(f2 & f3 & f4 ; "n")

to get the total number.