Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    10

    Question Unanswered: Displaying an access crosstab query in a table on an asp page

    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.
    Last edited by Simon K; 09-23-03 at 05:39.

  2. #2
    Join Date
    Sep 2003
    Posts
    10
    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
    Last edited by Simon K; 09-23-03 at 05:40.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •