Crosstab Query for entire database

C

Carla

I'll admit I'm completely Access ignorant. I'm taking a class next month.
However lucky me gets to support it and I have a client that asked the
following.

She would like to do a cross tabulation of an entire database. She doesn't
want to do it for each question. Can someone lead me in the right direction?
Oh yeah and it's Access 2003.

Thanks,
Carla
 
D

Duane Hookom

Crosstabulations are done "of" tables or queries, not databases. Access
doesn't have "questions".

Please find out some specific requirements regarding the crosstabulation
desired.
 
C

Carla

Basically she has survey results that she has pulled into Access and she can
run queries, but she is running it by office location (@ 10 locations) and
answer. She has to do a report for each answer and each location and would
like to combine it for all locations and q&a's. Also she would like a total
number of respondants per office location and a sum per question. She said
that crosstabulation is asking for a value and she doesn't have a value and
isn't sure what to put there.

Thanks,
Carla
 
Top