adding yes/no field

M

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
 
G

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.
 
J

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
Click to expand...

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Query on Yes/No Field 1
Using a Yes/No field to trigger a calculation in another field - J 3
Evaluate Yes/No Field Based on User Input 7
Yes/No Data Type 2
Access 2010 0
Checkboxes and Query Criteria 1
active date field 2
yes/no field and forms 1

Top