S
Sprinks
Sarah,
You will get a better response if you use the Subject line for a brief
heading, while including your entire question in the Message box.
The answer to your question is yes, however, if the selection in another
field determines the value of the boolean field, it is not needed in the
table and can be rather calculated on the fly in a query. The easiest way to
do this would be using a global function:
Public Function MyBooleanValue() As Boolean
Select Case MyOtherField
Case "Mary", "Joe", "Bob"
MyBooleanValue = True
Case Else
MyBooleanValue = False
End Function
Then in your query, created a calculated field, e.g.,
MyYesNoField: = MyBooleanValue()
Hope that helps.
Sprinks
You will get a better response if you use the Subject line for a brief
heading, while including your entire question in the Message box.
The answer to your question is yes, however, if the selection in another
field determines the value of the boolean field, it is not needed in the
table and can be rather calculated on the fly in a query. The easiest way to
do this would be using a global function:
Public Function MyBooleanValue() As Boolean
Select Case MyOtherField
Case "Mary", "Joe", "Bob"
MyBooleanValue = True
Case Else
MyBooleanValue = False
End Function
Then in your query, created a calculated field, e.g.,
MyYesNoField: = MyBooleanValue()
Hope that helps.
Sprinks