Cross Tab with Multiple Values

R

ray

Hello All,

I have a need to display volume and value in a crosstab
query. How can I do that? I do not wish to have the second
value as a row heading because the value are repeated with
each column heading.

In other words, I would like to have two a column heading,
a row heading and two values.

Perhaps something can be done with a union query.

Your help is appreciated.

Thanks,
Ray
 
Top