Cross tab query

[Noor]

I have an access file that is using cross tab query..

is there any alternative of cross tab query in sql server database.

will my access query run perfectly if i upsized to sql server?


thanks

NM

 

[Groucho]

You can try the RAC utility.It is somewhat
similar to the Access crosstab query but
much more powerful and has many options/features
not found in Access.Most crosstabs,like Access,
do not require any sql coding.

www.rac4sql.net

 

[Rod Scoullar]

Noor,

I doubt if the cross tab query will upsize.

You can code cross tab queries in T-SQL, although they are not as easy as in
Access. The Books on Line describe how to create them. Look up cross-tab
reports.

I managed to follow the examples and create my own.

Rod

 

[Groucho]

"Rod Scoullar" wrote in message

I doubt if the cross tab query will upsize.
You can code cross tab queries in T-SQL, although they are not as easy as in
Access. The Books on Line describe how to create them. Look up cross-tab reports.
I managed to follow the examples and create my own.

In Access do you use sql/vba code for crosstabs or use
the crosstab query.Get my drift.

Check out RAC for crosstabs and much more on S2k @
www.rac4sql.net