another crosstab question

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

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.

--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting

"Laura" wrote in message
...
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

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

--
Duane Hookom
MS Access MVP


"Laura" wrote in message
...
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