Yes/No data field?

[Parula]

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

 

[kathryn]

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

 

[Parula]

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

 

[kathryn]

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

 

[Parula]

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

 

[AlexMidd]

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