Cross Tab Query Help

[derekstewart]

I have a manufacturer #, a facility part # and a facility #. There is a consistant manufacturer #, but the facilities have been lazy and occasionally assign multiple part #'s rather than looking up the current part number. I am trying to do an audit with a cross tab query. I put the manufacturer on the row side, the facility # on the columns and the Facility Part Number in the middle. The problem is that rather than just display the facility part numbers, access wants me to use a function. I don't want to know that facility 5 has 3 facility part numbers for Manufacturer Part 354, I want the cross tab to show the actual facility part numbers. I works with the "first" or "last" functions, but then will only show one of the facility part #'s if a facility uses more than one. If I try and delete the function out of the design view, the query won't run. Any suggestions?

 

[dhookom]

You could set the value to a concatenation of all the parts for the Facility/Maufacturer. Check faq701-4524 for the code. There is a sample of how it is used at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

Duane
MS Access MVP
Find out how to get great answers faq219-2884.