Interesting problem, maybe...

[Gina Whipp]

Hello All,

I have a query that shows:

VendorName SpecificationID
Vendor A-101
Vendor A-200
Vendor B-400

What I would like to do is show on a report.

Vendor A-101, A-200, B-400, etc... going across.

The specification ID can vary anywhere from 1 to 20 or more. I am sure
there is a way to do this but I am at a loss as to how to do it. Can anyone
point me in the right direction?

Thanks,
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

 

[Duane Hookom]

There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

 

[Gina Whipp]

Duane,

You're a life saver (and a hair saver!)!

A big THANK YOU!
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II