Yes/No check box

[Fly Boy5]

I'm trying to store a 1 or 0 in the field but don't seem to understand how. I
made a filler feedback linked table with input form. I'm want to grade
several items, then total and come up with a % of failures.

Any help would be appreciated

Jim

 

[Pavel Romashkin]

I'm trying to store a 1 or 0 in the field but don't seem to understand how. I
made a filler feedback linked table with input form. I'm want to grade
several items, then total and come up with a % of failures.

Any help would be appreciated

Jim

A little more detail would be helpful, but I will venture a guess that
you could use option groups to directly bind to the table data. You can
set up option group radio buttons to return 0 or 1. Then, make the
option group bound to the Response field in your table. To get
percentage, run GROUP BY query on your table:

SELECT Sum(ResponsE)/Count(Response)*100 AS ReplyPercent FROM Table1
GROUP BY Customer_ID

or something like that.

Cheers,
Pavel

 

[Paul Overway]

Checkboxes are boolean....and store -1 or 0.