Yes/No check box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Fly said:
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
Click to expand...

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
 
Back
Top