Jan 12, 2001 #1 skeeton Technical User Jan 12, 2001 1 UA I used Crosstabs extensively in Access. I cannot see anything in SQL, should I use a Cube? Pathetic heh, but help appreciated.
I used Crosstabs extensively in Access. I cannot see anything in SQL, should I use a Cube? Pathetic heh, but help appreciated.
Jan 12, 2001 #2 TomSark MIS Oct 19, 2000 448 US Crosstabs are a front-end way to present data. You could attempt to use CUBE & ROLLUP if you wish, but I recommend you look into setting up an OLAP Cube. Tom Davis tdavis@sark.com http://www.sarkdallas.com Upvote 0 Downvote
Crosstabs are a front-end way to present data. You could attempt to use CUBE & ROLLUP if you wish, but I recommend you look into setting up an OLAP Cube. Tom Davis tdavis@sark.com http://www.sarkdallas.com