Output chart form from ck-box data

[Gandolf]

Access 97 pro’s,
I would love some guidance on a very basic problem. I have an input form that mimics its paper counterpart for ease of data entry, but I am having trouble getting the desired output. Here is an example:
I have a row of ck-boxes with the following labels: RN, LPN, HUC, Pharmacist, Technician, Physician, Student, Other. I have a corresponding Table with the same field names, so that one or more ck-box could be checked, resulting in a –1 appearing in the table, as opposed to a 0 for no ck.
What is the best way to create an output form that is a column chart with the field names as the labels to each column, and the input data summed up so that if RN was checked on 5 different records, the column for RN would indicate this? It takes me two seconds in Excel, but I’m missing the boat with Access. Thanks!
…A very rusty ...Gandolf

 

[doss]

Hello,

This may help. I'm using Office 2000 so hopefully you will be able to view the attached word document. The stuff in Access should be basically the same.

1. Make sure your totals are in the report footer.

2. The name and control source for the checkboxes are the same as the labels (rn, lpn, etc.)

3. The total fields are textboxes. Make sure that each on has the control source like this: =Sum([CheckboxName]*[CheckboxName]).

I'm attaching a file so you can see what mine looked like... sort of...

Hope this helps.

 

[Gandolf]

Maybe it's a querry problem, not a form?

Thank you doss!
I really appreciate the help. As I studied your answer, I realized how difficult it is to get the whole picture, or to accurately define the problem sometimes. I could not apply your solution to my problem, but you helped me define the problem better, and it may be a querry that I need.
I will post my querry question in that forum. Thanks Again!
...Gandolf