Post reply

Access Crosstab Query

  • April 11, 2005 at 12:53 am

    #66183

    The crosstab query was built in MS Access 2000. I need its equivalent in sql 2000 stored procedure.

    TRANSFORM Count(Quickvote.ID) AS CountOfID

    SELECT Quickvote.Comb, Count(Quickvote.ID) AS [Total Of ID]

    FROM Quickvote

    GROUP BY Quickvote.Comb

    PIVOT Quickvote.Location;

    Thanks.

     

  • April 12, 2005 at 12:30 pm

    #552210

    Check out the RAC utility for S2k.RAC is similar to Access crosstab but much more powerful with many features/options.And like Access it is easy to use.

    http://www.rac4sql.net

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply