Yes/No check box

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 Boy5 wrote:

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

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

--
Paul Overway
Logico Solutions
http://www.logico-solutions.com


"Fly Boy5" Fly wrote in message
...
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