another crosstab question

[Guest]

I hope someone can help me.

I want to make a cross tab of an equipment table. Some of the
equipment is available from 2 or 3 vendors.

I don't want a column heading for each Vendor Name. I just
want to have 3 colums. ex. Vendor1 Vendor2 Vendor3

Ex. Vendor1 Vendor2 Vendor3

amp Allied Newark PCPARTS

Thanks,
-Laura

 

[[MVP] S.Clark]

The values displayed on the column heading must come from data in a table.
Thus make a table that has the entries of Vendor1, Vendor 2, and Vendor 3,
and you can get the crosstab to perform as you desire.

 

[Duane Hookom]

There are some sample crosstab reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. One of them does this.
Check the Crosstab.mdb.