Making a cross tab in an Access Project View

[Guest]

How would I go about making a cross tab query in a view? Everything I see on
how to do a cross tab query they are NOT in a project. These instructions do
not work when you are dealing with a project. Thanks in advance for any help!

 

[[MVP] S.Clark]

Crosstabs don't exist in SQL Server.

When you're using an Access ADP, you're using SQL server, not Jet
databases...which have crosstabs.

--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

 

[Guest]

Well, I guess that explains that. Any suggestions on getting the same
results as I would in a cross tab query?

 

[Guest]

Hi HMote,

Don't know if you have found a solution, but I have the same problem - if
you go to http://groups.google.com/advanced_group_search?hl=en and type in
'adp crosstab' you will find a solution that works

regards

Ptero