adding yes/no field

[MaRSMAN]

How do I add a check box field to my query field name to be "Active"
I Tried Active:=yes/no,checkbox DIDN't WORK can you fix for me or is it
not able to do this THANKS MARSMAN

 

[golfinray]

You would add the check box (binary) field to the table the query is based on
then it will show in the field list of your query. Name it "active" in the
table.

 

[John W. Vinson]

How do I add a check box field to my query field name to be "Active"
I Tried Active:=yes/no,checkbox DIDN't WORK can you fix for me or is it
not able to do this THANKS MARSMAN

A Query has no independent existance: if you want this field to be editable,
it must be a field in the table underlying the query.

What exactly are you trying to accomplish?