Crosstab Query With Multiple Value Fields

[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

 

[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

 

[Duane Hookom]

There are several multi-value crosstab reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. There is also a method
that uses a cartesian type query combined with a crosstab. If the sample
doesn't work for you then come on back. The CrosstabReport.mdb should have
your solution.

 

[melody]

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

Thanks in advance,
melody

 

[melody]

Thanks, I'll keep this in mind

melody