Crosstab Query

Results 1 to 2 of 2

Thread: Crosstab Query

  1. #1
    Join Date
    Dec 1969

    Default Crosstab Query

    I have created a query similar to a "crosstab query" that you can create in Access. I would like the whole table of data to show on the page. I normally would create a table in html then spit out the data wherever I want it. Then loop through the recordset to produce my results. Instead of doing that I would just like to should the whole table on the page. Is that possible. In my asp and html could I write something like:<BR><BR>&#060;%= objRS.table %&#062;<BR><BR>Instead of <BR>&#060;%= objRS.Fields("Field1") %&#062;<BR><BR>&#060;%= objRS.Fields("Field2") %&#062;<BR> <BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default Nope

    not possible.<BR><BR>You could use .GetRows to put the records in an array, but you still have to loop through the records and columns.

Posting Permissions

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