Simple sql question

[mrdave9]

I have table A with a number of check boxes.



For a record in A I want to count how many check boxes are checked giving a number then update field in a corresponding record in table B with that number.

Both tables have same record key field.

I have coded the first part and have the count, but not sure how to code the UPDATE of Table B.

I want to do this as a event of a button click on a form.

[ranman256]

Your design May be wrong.
Table A ,record 1, should have 1 check box.
key, condition, chcheckbox,

from here you can count the checkboxes, update, etc.

[knarfreppep]

Try this -
UPDATE tblB LEFT JOIN tblA ON tblB.lngID = tblA.lngID SET tblB.bytCount = IIf(tblA.ysnQ1,1,0)+IIf(tblA.ysnQ2,1,0)+...

[mrdave9]

Will give this a try

[mrdave9]

worked great tks