calculate field value based on values in another field within the same table

[cattail]

I have a field "Detected" which is a binary response, 0 or 1. The other field is Point_Type which has 5 possible values where some indicate a bird was detected (1) and some indicate a bird was not detected (0). Both are within the same table.

I have over 10,000 observations. I am trying to figure out how to get Detected to autofill 0 or 1 based on the value of Point_Type.

Can some one get me started? I can work the logical coding but do not know where to start. Is this a conditional value? I'm not sure if this is a calculated value either.

Thanks

Cat

[comment]

The other field is Point_Type which has 5 possible values where some indicate a bird was detected (1) and some indicate a bird was not detected (0).

And those 5 values are: ... ?

[cattail]

They are all text values, "location_point", "location", "capture", "nest", "no detection", "search no detection", "no detection no point"

Sorry it really isn't 5, I didn't think that part would matter

Thanks

[comment]

So, assuming "location_point", "location", "capture" and "nest" indicate a detection, while the other three do not, you could make Detected a calculation field (result is Number) =

Point_Type = "location"

or

Point_Type = "capture"

or

Point_Type = "nest"

or shortly:

not IsEmpty ( FilterValues ( Point_Type ; "location¶capture¶nest" ) )

Edited November 13, 2011 by comment