I need to produce a report which produces an analysis grid for the results of a series of 8 option fields. To explain:
I have 8 fields to provide different ratings, such as “do you feel happier?”
These fields use option buttons on a form which set the database field to a value (1 to 5)
So I have 8 fields in a record that can each be set to a numeric value from 1 to 5.
I need a report to analyse this information in a grid such as this:
Question 1 Excellent [count] Good [count] OK [count] etc
Question 2 Very much [count] A little [count] Not at all [count] etc
I have never produced a report like this before. I could do it by creating a report containing subreports for each count. That would require 40 subreports with 40 queries and seems a bit clumsy. Is there a better approach to take before I start?
I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers.
Hopes this gives you ideas on visualizing your data in new ways ~
Create a calculated field in a query: