I have a datatable that collects how people responded to a question (scale of 1 to 30) from various states. What I want to do is to create a report by state of how each person answered the question, grouped by response. That is easy. What else I want to do is to create a report or query that displays a possible response, say 22, even if no one in a particular state entered that response. I tried creating a table with all possible options (1 to 30) and joining that to the datatable. I set the join properties of the options table to indicate that all entries in it must be used, but still an empty cell. Any ideas?