Report on crosstab Query when action is not in Query

[crimedog]

I have a table that has column: [actions] users input actions from a Combo box that provides 5 possible actions.


I want a report that sorts by chosen Month - and displays user then count for each action.
Created a crosstab Query that takes the month from a form and goes to report that works great. AS LONG AS all of the actions have been used at least once
If there is an action that was not used that month it errors expected value for " not found

What do you suggest?

[June7]

Need a dataset that pairs each of the 5 possible actions with every possible month. This can be generated with a query that includes Actions table and a dataset (table or query) of all possible months without a JOIN clause. This will cause a Cartesian relationship - every record of each table will associate with every record other table.

Then join that query to the table of monthly action data (compound join on action and year/month) and do CROSSTAB.

Actions are the header criteria for CROSSTAB? An alternative is to emulate a CROSSTAB with expressions. This would be fairly simple since you have only 5 possible actions. Review: http://www.datapigtechnologies.com/f.../crosstab.html