Crosstab Query With Multiple Value Fields

M

melody

Hi,

Is it possible for a crosstab query to have multiple value
fields ? Right now, all I can do is to create separate
crosstabs (four of them or so) and then join them
together.

Is a way to simplify this ?

Thanks in advance,
melody
 
Z

Zeppo

Life would be a lot simpler if you could get
your data into any version of server (including msde)
and use the RAC utility :~).

RAC v2.2 and QALite (free front end tool) for S2k @
www.rac4sql.net
 
M

melody

Thanks, it works :) Is it possible to get the aggregate
values into different fields instead of one field ?

Thanks in advance,
melody
 
Top