×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Yes/No data field?

Yes/No data field?

Yes/No data field?

(OP)
Hi everyone

I have a table that has a field with yes/no check box.

 
If you have table of customer and that as the field with yes/no check box.
I have query that uses zip code to pull the information  
When that record is use I would like the yes/no box to be check of automatically.
But after some time I would like that record to be come active again.
How can I do this?

Thanks
Paurla

RE: Yes/No data field?

Parula,

I'm sorry, but could you reword your question?

I understand that you have a table of customers and one field is a Yes/No check box.  What is the field's name?

You have a query that uses zip code as a criteria to pull up records.

When do you want the Yes/No field set to No?  Any time the query is run???

When do you want the Yes/No field set to Yes?

Kathryn
 
 
 

RE: Yes/No data field?

(OP)
Hi Kathryn

I am sorry about the confusion.

I field’s name is cust_in_sent.

I would like the yes/no field to be set to NO until I run the query.
When I do run the query I would like all the records in the table customers to be set to YES.
But after a few months I would like those records to be come active again.

I hope that this help you understand my questions batter.

I don’t have strong skills in sql so can you try to explain all the statements you writhe?

Thank you,
 Parula

RE: Yes/No data field?

You say "When I do run the query I would like all the records in the table customers to be set to YES."

Do you really mean ALL the customers, or just the customers who are returned in the query?

Kathryn
 
 
 

RE: Yes/No data field?

(OP)
Kethryn

i mean only the customers who are returned in the query.

also if i don't uses the yes/no check box. is there a way when i run the query more them once i don't get the same customers recodrs again?

thanks
Paurla

RE: Yes/No data field?

Basically you would do an update query, and set the 'Update To' box for the Yes/No field to Yes or True. This should set the field to Yes only for those records that satisfy the criteria specified in the query.

If the query is set to look only for those records with No in the Yes/No field you should not get the same records a second time.

Hope this helps.

Alex Middleton

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close