I have a table with a list of names e.g. surname, forename, telephone
number, emailaddress
I would like to show this in a table where the surname is the column heading
preferably with row heading showing what the data is.
Is this possible with a crosstab query and if so how?
Thanks
alec

Hello alec.

"Paradigm" wrote:
> I have a table with a list of names e.g. surname, forename, telephone
> number, emailaddress
> I would like to show this in a table where the surname is the column
> heading preferably with row heading showing what the data is.
> Is this possible with a crosstab query and if so how?

I think so, but it's quite horrible (the surnames should be unique):
Create a union query like the following:
Select "forename" as attribute, surname, forename as data
From [your table]
Union All
Select "telephone number" surname, [telephone number] From [your table]
Union All
Select "emailaddress", surname, emailaddress From [your tablename];

Then write a crosstabe query based on this union query that is grouping
by attribute and surname and uses the "first" or "last" function for data.
Use attribute as row heading, curname as column heading and the
"first of data" column as value.

--
Regards,
Wolfgang