Please help!

[cducote]

I am trying to generate a report from a form that has approx 100 "Yes/No" fields. The report will need to show all 100 fields with all records grouped by "No" responses to each. The data will come from a checklist of items monitored for Compliance/Non-Compliance. This is an example:
School is using state mandated forms - Then a list of those schools that had this item marked as "N0" (non compliant) would be listed. Any help setting up this report would be appreciated!
Charlotte

 

[tc3of4]

Hello,

I don't have access in front of me but I hope I can shed some light in the matter.

1) Since you are using a form to retrieve responses from a user then you should have a corresponding Table that will hold the values.

2) Now go to the Reports section and use the Reports autowizard button.

i) Select the Table
2) When asked to Group (should be the second part of the wizard after selecting the table) select yes/no field

continue on with the wizard...

This should show a report with all fields grouped by yes and no

hope this helps
tc3of4

 

[cducote]

I've tried this but the wizard only allows about 8 fields, and I am dealing with approx 85 fields. I might have to run multiple reports. Thanks for your reply!

 

[tc3of4]

Are the fields the Name of a school?
If so, why not try it another way, instead of having a table with 1 row, why don't you have a table with two fields... the name of the school and the other field containing the yes/no response... with 100 records.

Step 1: Creating the table
Lets just call it --> SchoolDetail
# of Fields in Table: 2
Field1 name: School Name
Field2 name: Compliance <-- Yes/No type

Now type in all the detail that is available, I'm assuming just the school name for now.

Step 2: Creating the form
Use the table SchoolDetail as the recordsource for the form.

1) In the Form Header put two Labels.
One Label with caption: School Name
the other with caption: Compliance/Non-Compliance.

These will be the Header for the detail below...(to follow in step two)

2) In the Form Detail, create one Bound Text boxes and One bound Check Box.

Have the first Bounded Text box have the recordsource = School Name (Have the property Locked = true --- so you cannot change the name of the School)

Have the other object - Bounded Check box have the recordsource = Compliance

Now when you run the form it should show all the school name with a check box beside it.

Since the Check box is bounded, anychanges made to the Check box will be reflected in the Table.

After that you can create the report from the table with the valid entries.

Hope this wasn't too confusing... If so I can send you a demo database in Access 2000 format.

tc3of4

 

[Richie]

As you've already realised you have a logistical nightmare trying to produce this report the way you want, instead of 85 reports you could use one just selecting different responses for each print, or you could group by school showing all non compliance by filtering out yes responses,that of course makes the report more difficult to use. Best of luck either way.

 

[cducote]

Thanks for the suggestions! I've redesigned my original table and life is MUCH better now! This forum is a lifesaver!
Charlotte