Adding up for a report

[rob0211]

I was assigned to make a database. Not a clue about access. It was a survey, I have everything finished and all data in there. Now I have to create a report. There were 4 pages to the survey so I have 4 tables and 4 forms. I have numbers 1-5 in a text box for excellent, good, poor..ect. How can I get a report that tells me how many 1's, 2's ect. there are, and to include the coments entered.

All help is greatly appreciated.
Rob

 

[bethabernathy]

Hi - This might work. In your report go to Sorting/Grouping by right clicking on the properties of the report. Then create a group header & group footer for that field. It should sort out the numbers. Then add a text box into the group footer that calculates the field. So, it would be something like this:

=Count([yourfieldname])

If I am understanding what you want to do, this should work.

Let me know if you need any more help or if this gets you closer to what you want to do.

Beth