Results that go across instead of down, is it possible?

[Guest]

Ok, here's what I have...

Groups, let's say 1-18 (which it actually is), that are actually in a table
but I will just put these as static numbers across the top of each grouping
(1 2 3 4 5 etc.).

Now I want to output a table of different questions that have been asked in
a survey down as a normal report would do, but across from each question, I
would like to list the count of each response that fits into the groupings
that I described above.

It's sort of like a pivot table of sorts, or a cross-tab query, but I cannot
make a cross-tab query when in a project.

Any ideas on how to do this in a report? I can already get it to do what I
want to in this formatting:

How old are you?
1 - 0
2 - 0...
30 - 233
31 - 352
32 - 372...etc.

Thanks in advace!

 

[Larry Linson]

"In a project"? You mean this is an ADP? Perhaps you could employ some of
the analysis functions of Microsoft SQL Server, instead of Cross Tab.

I haven't tried to do anything with Pivot Tables in ADPs, and now that the
Access team in Redmond recommends MDB and ODBC over ADP and OLEDB for
accessing server DBs, I am not motivated to invest any additional time or
energy in ADPs.

I'd guess you might stand a better chance of getting a good answer in an SQL
Server newsgroup, because even though you want to display the result in an
Access Report, it is really a question of getting the data you want to show,
rather than how to show it.

Larry Linson
Microsoft Access MVP