Cross tab query

  • Thread starter Thread starter Noor
  • Start date Start date
N

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
 
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
 
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
 
"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.
Click to expand...

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
 
Back
Top