Hi,

I have a crosstab query created in SQL and I need to display the results with headings in a table on my asp page. I have the SQl which works, and have opened a connection, but don't know how I would get the results of the SQL into a table. Can anyone give me any pointers?

Cheers.

Simon.

More info....

The table will take the following form:

1996 1997 1998 1999 2000 2001 2002 2003
Agcas 22 88 89 98 102
GSF 55 44 21 78 56 98 102
TGFL 0 0 0 0 12 55 89
SERF 0 0 0 12 55 77 32

Headers down the left are the FAIR_ID's and at the top are the AgYear. The table that I get this data from is called FAIRDETAILS. The data in the middle is the result of the query.

The SQL that generates this query is as follows:

TRANSFORM Count(FAIRDETAILS.FAIRS_ADMIN_ID) AS CountOfFAIRS_ADMIN_ID
SELECT FAIRDETAILS.FAIR_ID
FROM FAIRDETAILS
GROUP BY FAIRDETAILS.FAIR_ID
PIVOT FAIRDETAILS.AgYEAR;

Can anyone give me any pointers?

Cheers