R
Ruben
How can i convert crosstab qry to ADP using sql server?
M
Michel Walsh
Hi,
Directly, you cannot.
With Access 2002 or 2003, you can use a Pivot Table.
You can use a : SELECT SUM(CASE( f1=pivot1, value1, 0)) AS pivot1,
SUM(CASE( ... ad nauseam. That assumes you already know all the pivot
values.
You can use RAC (not free, see
http://www.angelfire.com/ny4/rac/racv150.htm, but there is more recent, I
think)
You can use heterogeneous processing, if the sys admin allows it. Add a
mdb as a linked server that will that will execute and return the result of
the crosstab. Edit the mdb to, itself, have linked table to the original MS
SQL Server (and sure, must have the crosstab pre defined, in the mdb).
Hoping it may help,
Vanderghast, Access MVP
Directly, you cannot.
With Access 2002 or 2003, you can use a Pivot Table.
You can use a : SELECT SUM(CASE( f1=pivot1, value1, 0)) AS pivot1,
SUM(CASE( ... ad nauseam. That assumes you already know all the pivot
values.
You can use RAC (not free, see
http://www.angelfire.com/ny4/rac/racv150.htm, but there is more recent, I
think)
You can use heterogeneous processing, if the sys admin allows it. Add a
mdb as a linked server that will that will execute and return the result of
the crosstab. Edit the mdb to, itself, have linked table to the original MS
SQL Server (and sure, must have the crosstab pre defined, in the mdb).
Hoping it may help,
Vanderghast, Access MVP
G
G.C.Mandrake
..
Kind of you Michel
The RAC site is:
www.rac4sql.net
You can download a demo and play with it with full functionality
for 30 days.
Kind of you Michel
The RAC site is:
www.rac4sql.net
You can download a demo and play with it with full functionality
for 30 days.