Arthur Fuller
fuller.artful at gmail.com
Wed May 27 10:32:19 CDT 2009
PIVOT should do this for you. A. On Wed, May 27, 2009 at 12:16 PM, Andy Lacey <andy at minstersystems.co.uk>wrote: > Hi folks > This should be simple but I can't see it. > > Have a query which gives a list of raw materials and suppliers, ie > > Mat1 SuppA > Mat1 SuppB > Mat1 SuppC > Mat2 SuppA > Mat2 SuppD > > and so on > > What I want is a query result for extract to Excel which transposes the > suppliers into columns giving a single row per material. Thus: > > Mat1 SuppA SuppB SuppC > Mat2 SuppA SuppD > Mat3 SupZZ > etc > > We must have had this a zillion times but I can't get it to go. > Heeeeeeeeeeeellppppp! > -- > Andy > > ________________________________________________ > Message sent using UebiMiau 2.7.2 > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >