Count Checkboxes in a query

[MaxEd]

Ok I have a table that contains 138 check boxes with 2 dates (tblDataAudits). This table is used as an indicator for the data entry person for errors found during their audits.

It contains a recordID that corresponds to a particular person, but the table containing the person's data will be purged if it's older than 5 days. The data files however are always saved on ther server so I can reimport them into the database at a future date.

What I want to do is store the person's record who had an error along with the particular recordID that mathes up with the tblDataAudits into a seperate table. I know how to manulally add a record into a seperate table but my problem is finding the records in the tblDataAudit that have checkboxes that are checked.

Thanks!

 

[PHV]

Take a look here:

http://www.abcdataworks.com/fundamentals.htm

If you don't redesign your database, I'm afraid you have to build a query with 138 OR conditions.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[MaxEd]

I think I know what the problem is with my design. I will just wipe out the checkbox table and just add each audit as the user clicks the box. Thanks!

-Laughter works miracles.