Yes/No check box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Fly Boy5 - 26 Apr 2005 23:15 GMT

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

Reply to this Message

Pavel Romashkin - 26 Apr 2005 23:39 GMT

> 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
[quoted text clipped - 3 lines]
>
> 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

Reply to this Message

Paul Overway - 26 Apr 2005 23:46 GMT

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

Signature

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

> I'm trying to store a 1 or 0 in the field but don't seem to understand
> how. I
[quoted text clipped - 4 lines]
>
> Jim

Reply to this Message