Forcing categories in rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi guys,

Hoping you can help me.

In a crosstab query, you can force data into set columns by using 'IN'. eg
by having the column field be:
[Employee Category] In ("Full Time","Part Time","Sacked","Wish they were
sacked")

you can ensure the categories requested appear, even though there maybe
nobody in the data table holding that category.

I need to do exactly this BUT I need to do it by rows. Can it be done? If
so, how?

Many thanks for your advice.

Basil
 
Basil,

The best way to do this is with another table or query (I'll call this T1)
that returns all of the "row" values you want. Then use a left join to join
this query to the dataset your where your other data resides. Then, use the
T1.yourField values as one of the RowHeaders. This should ensure that all of
the rows you want are present, and that the values in your crosstab query
relate to those rows.

HTH
Dale
 
Back
Top