[AccessD] Cross-tab (I think)

I think it should too Arthur but I'm damned if I can see how. When I try to
do a pivot I get all of the supplier names (hundreds) shown as column
headings. Not what I want at all. Anyone know the trick?

--
Andy


--------- Original Message --------
From: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Cross-tab (I think)
Date: 27/05/09 15:35


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
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

________________________________________________
Message sent using UebiMiau 2.7.2