Access Crosstab

Results 1 to 2 of 2

Thread: Access Crosstab

  1. #1
    Join Date
    Dec 1969

    Default Access Crosstab

    Hi is there a way to do the crosstab query in Access without using Transform and Pivot but using temporary tables?<BR><BR>Or is there a way to write a crosstab query as SQL Stored Procedure?<BR><BR>Thank You.

  2. #2
    Join Date
    Dec 1969

    Default RE: Access Crosstab

    Yes to point 1.<BR>Use VB Code to loop through the recordset select record values to suit and save them in the temporary table to the format that you want. Could take quite a bit of coding depending on what you are trying to achieve.<BR><BR>I will not be fast to build but warehousing the data off into the temporary tables will make it fast to retrieve. Like building n dimensional cubes. I think SQl Server would be faster using OLAP but I haven&#039;t ever played with it

Posting Permissions

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