Multiple field into limited number of columns

[seat172]

I have a table that shows warehouse locations thus:

Part No Location
A1234 A1
A1234 A2
A1234 A3
A1234 A4

There may be only the one location, or, as above four, I need to display the first three locations for each part side by side:-

Part No Location1 Location2 Location3
A1234 A1 A2 A3
A3456 B1
A4567 C1 D1

And so on, about 11,000 parts in 27,000 locations.

Havent got a clue how to do this and my SQL is very limited, only just starting down that route.

Any help would be greatly appriciated.

Thanks

 

[pbaldy]

You could adapt this to your needs (think TOP predicate):

http://www.mvps.org/access/modules/mdl0004.htm

 

[Uncle Gizmo]

This post has a download that may provide some inspiration, or possibly perspiration!