FORCE ROW HEADINGS IN CROSSTAB QUERY

[laman]

Is there a way to force row headings (not column headings) in a crosstab query. I would like the same row headings to show each time even though some of them dont appear in the table. There are ten possible headings for the field in question.

THANKS FOR ANY HELP!

 

[Steve101]

(a) Why not create a table with the ten or so valid row headings, then link to this table in a join based query based on some many to one rule associated with a column in the crosstab query, or

or ...

(b) Use some code to "convert" a row value associated with the crosstab table, into one of the 10 row values you want, based on your rules for selecting the 10 values.

You're a bit vague about your requirement, so its difficult to be more specific.