Yes/No Data Type

[Guest]

I have a table that contains a column with a data type as Yes/No (check box).
The table is a customer table which includes name, address, zip code, etc.
and the check box. I then have a form which contains a subform query listing
the zip codes, retailer counts in each zip, and the Yex/No (check box) from
the customer table. The user can click on the plus signs next to the zip
code in the subform and view all accounts including the Yes/No box.

The user can check each box next the accounts, however cannot check the box
located next to each zip code. I am looking to allow the user to check the
box on the zip code row, which will then automatically check all accounts
linked to that specifc zip code. This will save the time of clicking the
plus sign and selecting each account Yes/No. Can thiss be done?

Thanks,
Matt

 

[Joseph Meehan]

Sure it can be done. There are several solutions, but I would normally
use an update query run at the end of the data entry process to do the job.

 

[Guest]

I tried selecting the check box next to zip code and the unfortunatley the
query doesn't allow a check. I only can check the boxes next to each account
after clicking the plus sign and viewing the subdatasheet, not the zpi code
datasheet. Please remember I have a datasheet which include the zipcodes,
retailer count, check box then a subdatasheet with the corresponding account
name, address, and check box. Do I have to create a sepaate table containing
the zip codes then link the account table? I am currently running a query
that performs a group by from the account table.

 

[Joseph Meehan]

I tried selecting the check box next to zip code and the
unfortunatley the query doesn't allow a check.

I am not sure what you meant by this. Why does the query not allow
this? Is it a relationship issue?

I only can check the
boxes next to each account after clicking the plus sign and viewing
the subdatasheet, not the zpi code datasheet. Please remember I have
a datasheet which include the zipcodes, retailer count, check box
then a subdatasheet with the corresponding account name, address, and
check box. Do I have to create a sepaate table containing the zip
codes then link the account table? I am currently running a query
that performs a group by from the account table.

Is the subform based on another table? Due you have a single table for
all stored data?

Maybe we need to start with with your table structure. How many, what
kind of information is stored in each and how are they related.